VBA - Running Macro from array / list

Month End Master Template - example.xlsHi all,

I hope somebody can help. I have a basic knowledge of VBA (although usually just record macros).

I have a master spreadsheet which needs to be completed and distributed monthly, containing customer information split in to a number of tabs for various products. All 1000 customers are assigned a regional identifier (like a bank sort code). eg:

London - 11111
Southend - 22222
Portsmouth - 33333

The identifier for each customers' region is in every tab in the same row as their name.

One tab in the master spreadsheet contains all region codes.

I have some macros written already on my master template. My logic...

Filter each product (each tab) in the master template by first region code (indentifier) in list (DONE)
Copy filtered info (DONE)
Open New Work Book (DONE)
Paste each tab (DONE - long winded, would welcome any quick copy and paste coding)
Rename each tab in line with master template (DONE - but as above)
Save workbook with file name "[regional code]" (DONE)

Repeat for next indentifier/region code in list (THIS)

In particular, I need the macro to look at the list of region codes one at a time and perform the below functions before moving to the next region code and repeating. It is the last point that I am struggling with!


Thank you for your help

Regards
B