Combine data from multiple tables

[dw_22801]

Hi,

I have a workbook that has multiple tabs, each tab having two tables of data. One table just pulls data from the other. I paste data into the first table on the tab, and it populates the second table in a standardized format. I then have to copy/paste each one of these tables into another workbook. I am trying to create one tab, with one table, that compiles the data from all of these standardized tables. I can attach a sheet if necessary, I was just trying to avoid creating sample data. Thanks!

[alansidman]

Here is a link to demo a power query option.

https://www.youtube.com/watch?v=OFt9b6DgvY0

[dw_22801]

Yep, after I posted, I found this was probably a good option. I'll check it out. Thank you very much!