I solved this by renaming sheet 1 as 'Data', sheet 2 as 'Data1', sheet
as 'Data2' and sheet 4 as 'Data3'. but this is too much trouble and i
puts nothing into the sheet called 'Data'. Is there any way of makin
this work without havin to change the names of the worksheets at all
i.e. leave them as sheet1, sheet2, sheet3?

--
Message posted from http://www.ExcelForum.com