VBA 400 Error when switching sheets

Here is my code below and I keep getting an error 400 message as soon as the code goes to the Priority Unique tab. It doesnt do anything on the tab except select it and then sends off the error. Thank you for the help.

Please Login or Register  to view this content.

I am taking data from the template (2) sheet to the Macro Test sheet. Once that data is copied in I am trying to generate a unique list of data for each section by copying the section over to another tab and running an advance filter on it for uniques only. My code is below and this is a very important project I am trying to do so any help would be greatly appreciated. I keep getting an error 400 message as soon as the code goes to the Priority Unique tab. It doesnt do anything on the tab except select it and then sends off the error. Thank you for the help.

Is that a sheet in the active workbook? If not, activate the workbook, and then select the sheet.

That said, it would be better if you removed all the Selecting from your code.