Can you define "having trouble?"

If you identify the source worksheet correctly, there should be no problem.
Posting your code would help.

--

Vasant


"GregR" wrote in message
oups.com...
I am having trouble with the code to copy the sheet values to a new
workbook where the copyfrom WB has multiple sheets. The number of
sheets may vary, but always more than one. TIA