I am trying to write a macro which opens a workbook, selects data and
copies it to another workbook. This is to list outstanding items.

My problem is the workbook has various sheet names, the workbook is
updated regularly and I do not have control of the sheet names.

I would like to have something along the lines of

-Open workbook (I can do this)- :)
Select First Sheet (unknown name)
-Select/ Copy/ Paste Information (I can do this)- :)
Select Second Sheet (unknown name)
-etc etc etc-

The next problem is as records are added or removed so the number of
sheets varies. I need something that will start at the first sheet and
continue on to the last without specifically indicating the number of
sheets.

Any help would be greatly appreciated as I do this manually at present


--
Donkin
------------------------------------------------------------------------
Donkin's Profile: http://www.excelforum.com/member.php...o&userid=23715
View this thread: http://www.excelforum.com/showthread...hreadid=482732