Copy Rows with "Closed" in Cell to the bottom of the existing data in Sheet5

Hi,

I have used a formula to achieve this before which seemed to work although now it seems to be replacing other data already in the worksheet so I am unsure of how to fix, thinking I should just start again.

The file in question is a tracker of activities, Column A (sheet1) is the Status and once the status is "Closed" I need to run a macro that copies all closed activities to Sheet5 at the bottom of previous closed activities. Once this is done I already have a macro to delete all "closed" activities from Sheet1 meaning that it is vital the new closed activities stack onto the bottom of previous closed activities.

The Column Headers start on Row 11 with activities running from Column 12.

I am very new to Macro's so am learning very slowly - I would be very thankful for any help

Thanks!