1) bring in 9 separate data sources (main table joined to reference table). Build a bar chart with summary for each source on 9 separate sheets. Build a dashboard that stacks the sheets 3x3 style. You can probably use an arbitrary date and "apply to all related data sources" so the dashboard components update together.
2) bring in 9 separate data source and blend on a common data field. Attempt to build on a single sheet. Sounds like it may get cramped.
3) Try to union the 9 tables together. Without seeing the data snapshots, I'm not sure if this is a good option. You'll need same number of column (and in same order) for each table. You can explore joining in reference tables post union.
Thank you for your idea. Really appreciate your help!
Your first one and third ideas sound very creative. At present, I'm trying to do your Second one. First, I join one table with he reference table, and I use it as my primary table, the I data blend other tables one by one with the primary table. Yes, it really looks very cramped. I'm very interested in your first and third one. I attached my workbooks by adding some tables data there. Please help! Thank you very much!
P.S I'm trying to find where I can attach my update workbook here by replying to you.?