Macro does not work with protected sheet

Thanks a lot for your help for sorting the code for me! Massive help!

You're welcome. Always happy to try and help a fellow Aussie and thanks for rep

This line of code...

For Each ws In Worksheets

...loops through all the sheets in workbook.

This line of code...

If ws.CodeName <> "Sheet2" Then 'References the code name of the tab.

...tells the code to ignore the code name of "Sheet2" as this tab is where the results are consolidated so it makes sense not to filter and copy its data. The code name of a sheet is found in the left-hand panel of the Visual Basic Editor (where the macros are housed). In your workbook's VBE you will see Sheet2 (Disposed) where Sheet2 is the code name and Disposed is the actual tab name you see from Excel's front end. The benefit of referencing sheets via their code name is that the tab name can change but the underlying code will still work. You can also change the code name of the tab if you wish via the VBE.

This line of code...

ws.Protect Password:=123, DrawingObjects:=True, Contents:=True

...sets the level of protection for the sheet. You see these options from the Protect Sheet dialog i.e. when you manually protect a sheet via the Protect Sheet option of the Protect tab from the Review ribbon. These are the default selections.

Hope that helps.

Robert