I need a way to create a summary page that queries data across mutiple tabs.
Each tab contains specific user data. I want the summary page to list an
overview of each user. I've been doing this via a Pivot Table but is there a
way that doesn't require me to compile all the data together in one worksheet
to query?