I have a workbook with 5 tabs: North, South, East, West, and Summary.
Although the number and structure of the columns is the same on all 5 tabs,
the number of rows varies on the first 4 tabs. I need to periodically
consolidate the data on the first 4 tabs over to the Summary tab, and
ideally, I would like the consolidation process to occur automatically.
Can someone tell me the BEST way to proceed? I'm not sure if I should be
using Lists, Microsoft Query, or some other approach. Any guidance would be
greatly appreciated.
Thanks.