Hi

I have the following:

A workbook with the sheet names: P1, P2, P3 etc.

A folder with files called P1, P2, P3 etc. Each of the files contain a sheet looking like this:

untitled2.jpg

Now i need for excel to look i the folder for the file P1, open and copy from B12:E36 and H12:K36, to the sheet in the master workbook named P1. The same for P2, P3 and etc.

Anyone with a good idea?

Thanks in advance!

Regards
Niels