I am ready to try RDB's macro for consolidating several worksheets into one
using Excel 2003.

1. In preparing the worksheets to be used for consolidating, do i need to
delete rows that are not "data" rows?

I would still need them in the final worksheet but more for formatting the
report.

2. If answer to 1 is yes, is there any way to automate the report formats in
the consolidated/merged worksheet?

Thanks greatly!