DBsWifeLB wrote...
I have a multiple page workbook and I need to consolidate all the
information on one page.
Problem is that some of the pages have different information than
others and I need all line items accounted for. I do not want to put
un needed information in all reports to make one unified report form as
it would be too big.

Any ideas how I can best do this?

Too vague.

You may want to consider adding a blank worksheet and using it to
consolidate information from the other worksheets using simple formulas
like =AnotherSheet!X99. You could leave the formulas in the other
worksheets alone and still give the impression that you've consolidated
everything into a single worksheet.