Merge tables/cells from multiple worksheets

[cpking]

I have a workbook that contains several worksheet, each with exactly the same layout but differing data. This is an expense report and each worksheet is a different employee's expense report. Each sheet has varying numbers of entries, and is broken into (possibly) two pages. Page 1 and page 2 totals are added and summed at the bottom of the first page as most reports are only one page long. Each of the two pages contain tables of that set of expenses. For example, Clayton's expense reports consists of Clayton1 and Clayton2; Mitch's are Mitch1 and Mitch2, and so on.

My goal is to consolidate the nonempty rows of each table into a new worksheet. This worksheet would follow the same layout as the expense reports, but would also have additional columns used to manipulate the data, all for the purpose of importing into Quickbooks later.

Any thoughts on the best (and easiest) approach?

 

[vw412]

Some questions:

Are you wanting to consolidate each employee's two expense report pages into 1 single worksheet? Or are you wanting to consolidate all employees sheets into one "master" sheet?

The new worksheet that will contain the consolidated data, should it only have detail data or should it also have all the totals/subtotals and any other non-detail data?

Will the consolidation process simply be a straight copy of rows or will there be some data merging or manipulation involved?

Could you perform the process you want done by hand and track all the steps you performed to get to your final product? That will go a long way to helping you automate the process.