Dynamic Tables

Hi,

I have this worksheet consisting of tables and each table is meant to pull relevant rows from a corresponding worksheets within the same workbook (Just say the relevancy is according to a flag column in each of these raw data worksheets). Each table will have a row of column headings and a row of totals at the bottom. I don't want to reserve a maximum number of rows for each table as it will lead to many unused blank rows.

I thought about the following methods but are impractical for this case:

1. Copy everything from raw data sheets to the first one and use auto-filter on flag column for each table (not desirable as raw data sheets are huge; total row does not sum filtered rows only).

2. Use PivotTables (okay but with considerable formatting draw-backs - would like to see if we have any alternatives).

Thanks in advance guys.