Copy Data from multiple sheets to Main datasheet

Hi Bogleda,

Can I add line items (Rows) to the existing info datasheets that will copy over to the TOC?

Can I add info datasheets to the workbook and would they be included with the copy code?

You'd have to disable events and rerun the :Bogleda for that

Can the conditional formatting be copied with the data to the TOC?

The program would have to be rewritten to transfer the Conditional Formatting

I used "Writing Excel Macros" - O'Reilly by Steven Roman
and I bought "Excel 2003 Power Programming with VBA" by John Walkenbach.

But we have a Tips and Tutorials Forum with many good suggestions