Power Query

[Rcaaa]

I have several workbooks that I want to combine into one. I want to be able to easily pull information about each project based on the assigned ID. The workbooks have different columns, but all of them will have the ID.

How would you combine the data?

I was thinking using a power query, but I am not sure if I should combine the queries or make connections.
If anyone has resources that will help me with this question, I would appreciate it.

Thanks,

RCAAA

 

[sandy666]

merge tables by ID