I have 30 workbooks with one sheet each. All sheets are identical in
structure, only the data varies. What code will copy the sheet in each
workbook to a new sheet in a consolidated workbook. Note this is not a merge.
I need 30 sheets in the consolidated workbook.

Best regards,
--
Drew Yallop