Sorry I didn't respond earlier...been very busy.

Yes, the cells are in the same locations on each page. So I would be
exporting data for the same cells on every sheet to a new worksheet.

So data from H6 on WkSht 1 would go to cell A1 on New WkSht
data from H6 on WS 2 would go to A2 on New Wksht and so on. Thanks so
much for your help.


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=488524