Usually not. In a layered preparation, overlap or patch the torn area and continue building the layers as the recipe directs. Reserve a more intact sheet for a visible top when appearance matters. Small tears hidden between layers generally do not require discarding the whole sheet.
King Arthur discusses returning softened butter to the fridge, but very soft or partly melted butter may no longer behave the same in the intended recipe. Follow storage directions and avoid using questionable butter.