Macro for copying ?
 

Hi, can someone please advise/help with writing a macro to cut all of the
inputted rows from a master spreadsheet ('MASTER DEPOT & OFFICE v1.3' tab
'ALL') into a separate tab (MASTER) including only the 1 particular site.

Master spreadsheet info:
Headings run from A2 to AH2
First inputted entry on row 3
Last inputted entry on row 7000
Location data of intersest in column AF
I need to do this process for numerous sites.

Please help!

Thanks.