Forum Discussion
copy live table data from multiple tabs
You may use Power Query to combine them and load result to master sheet.
I am going to suggest that you reverse the process. Reverse the thinking behind your current design.
Start with a combined table that contains all of the data currently in five separate tabs, merely adding a column that differentiates or identifies which team the rest of the row refers to. You'd accomplish this right now by simply copying all of those tables onto a singe tab, adding the aforementioned column.
Once you've done that, it will be easy to extract the data for a given team, for reporting and status report purposes. You could also extract all completed projects (or whatever it is that is being tracked) for each team, sorted in whatever order.
This is very easy if you have the most current version of Excel, the version that contains the FILTER and other dynamic array functions. Here's a video that explains those functions.