Speed up Macro

Hi all

I have this macro which searches through dozens of spreadsheets based on a specified list, here is the code:

Basically I am looking at ways to speed up the the running of the macro as it takes about 15 minutes to go through about 50 spreadsheets. Attached is the report runner spreadsheet this macro is contained in (Unsold Tickets button in 'Unsold Ticket Report'). Also attached is a sample spreadsheet where the data is pulled from (Judas Priest) and the template where the information is output on (Unsold Tickets). Thank you in advance!

Please Login or Register  to view this content.

Turned screen updating off. Defined worksheets to use fully qualified to use as objects. Turned all activates off.
I can't test it, of course, but good luck.

Please Login or Register  to view this content.