Hi, i am struggling to find some code i need to automate a report for a project at work.

I have a workbook called "Store Record Card - Commercial New TEST.xlsm" with a tab "store graphs" and a list of branches and regions in rows 2 to 37 (which are hidden, see below). The branch list relates to a data validation in cell b1 which runs the tab, every time you change the drop down box in cell b1 to a new branch, the tab then reflects the branches sales below etc..

I need a macro which runs through the list in b1, copies and PSV's the "store graphs" tab into a new workbook. I need the macro to create 5 regional workbooks each with there respective branches in and the regional summary. Then i need these 5 workbooks saved on the network as the region name and date (mmm/yy).

(C3:C36) (F3:F36)
Branch List Regional List
BARNSTAPLE Region 1
BIRMINGHAM Region 3
BRISTOL Region 1
CAMBRIDGE Region 5
CARDIFF Region 2
CHELTENHAM Region 2
COVENTRY Region 4
HALL GREEN Region 3
HEAD OFFICE NA
HEREFORD Region 2
HULL Region 4
LEICESTER Region 4
LICHFIELD Region 4
LIVERPOOL Region 3
LONDON Region 5
LUTON Region 5
MANCHESTER Region 3
NEWTON ABBOT Region 1
NORTHAMPTON Region 4
NOTTINGHAM Region 4
OLD HO SALES NA
PLYMOUTH Region 1
SOUTHPORT Region 3
SWANSEA Region 2
SWINDON Region 1
TRURO Region 1
WORCESTER Region 2
WREXHAM Region 2
YEOVIL Region 1
Region 1 Region 1
Region 2 Region 2
Region 3 Region 3
Region 4 Region 4
Region 5 Region 5

Can anyone help me with this as i am struggling.

Thanks in advance