VBA Macro to copy specific cells in different workbooks to a single master workbook

[MarkR3003]

Hi

Dont know where to start with this request....

I have many excel files all of exactly the same structure with different data but each one is saved / named differently - lets call these files 'Form 1.xls', 'Form 2.xls' and 'Form 3.xls' - see attached

I want to be able to open each file called 'Form 1 etc' in turn and use a personal macro to copy specific cells in this file and their values into a master workbook into a common table to bring all the information together - lets call this file 'Master.xls' - see attached

Form 1

Form 2

Form 3

Master

Appreciate any advice or VBA code that I could start with


Thanks

 

[MarkR3003]

Many thanks again. Simple when you know how!