I have many workbooks in a directory (c:\East\), and I need to copy the same range of cells (A99:BM99) from a specific sheet ("General") and paste them into a file (Master.xls).
So the copied range from the first file in the directory will be pasted in row 2 of master, the copied range from the next file in the directory will be pasted into the next row (row 3), and so on.

Any suggestions?

Thanks!