Consolidate text data from multiple tabs into one table

I have 5 tabs that will update automatically on a weekly basis, based on weekly updates from XML files. The data range (rows) will grow in each of the 5 tabs on a weekly/daily basis. The columns in all tabs have the same heading and will remain the same throughout.

I want to get the info on all 5 tabs into one table on a separate tab that I sort and manipulate.

I could do this with formulas if my range wasn't constantly changing, but don't know how to do it with a moving range.

Please help. Thanks

I am really good at formulas in excel but don't know how to use or set up macro's. Based on my research, I thought using macros would be the answer, but I am having a hard time learning how to do them.

Though, now that you have confirmed that is a possible solution, I will dig into it more.

I am not seeing the data output. I can get to your code, but I don't actually see the table. I have enabled macros.

Thank you. That seems to be working. I am running into some additional issues with the output, but let me do some testing. Thanks again

How do I get the table to clear prior to it running everytime. Right now it seems to just add on to the end each time it runs.

Thanks again. So to run this macro, do I need to hit the Alt F11 everytime and go in and run it, or you said I could build a button to run it. Can you give me the quick and dirty on that? Thanks

Thanks again!!!