merge worksheets

[LLOYD6664]

i have 300 workbooks each of which has an identical worksheet within I need to create one worksheet from them

can any one help please I need this urgently and I cant figure it out.

[alansidman]

Here is a link that I recently provided code for a similar project. Look at it and you should be able to modify to your needs.

http://www.excelforum.com/excel-gene...worksheet.html