I am new to macros and got a simple one to work that would unlock the sheet, refresh pivot table and then relock the sheet, but now I am getting error 1004 implying there are multiple pivot tables on the sheet or such.

This is my first attempt to protect parts of sheets on several pages in a workbook.  There are single pivot tables on 3 sheets that all pull data from a main sheet in that same workbook.  It would be ideal to have them all refresh at once.

I don't know how to do the programming part of macros. I only learned how to try to record a macro so far.