Pulling data from multiple workbooks

[jprlaw]

Is there a quick way to pull data from multiple different workbooks within the same folder.

The cell references are identical for each workbook ie B19, B20 etc and are always located on sheet 1. but the files have completely different names. is there a macro i could run/write to open each workbook in turn, copy the cells in question, and paste them to a seperate workbook , then open the next workbook from the folder and repeat the process ?

Thanks in advance for your help

 

[BrianB]

This gives the basic structure. You will need to change the subroutine at the end.

http://www.mrexcel.com/board2/viewtopic.php?t=145246&highlight=