Macro To Merge Tables in a WorkBook

Hi,

I am trying to figure out a way to merge the tables i have on separate tabs into one table on another tab. I have uploaded a sample file with the desired out come. Also, as you will see, i would like to show the Reference Number of the table. Ex. Table1 would give 1 or even just Table1. I dont know if i am being to vague or not. Any help is greatly appreciated!

alan,

This works decently well, better than i am capable of. However if the master table already has rows in it the copied data gets spaced strangely. It works fine if there is only one row in the master table, except that when you run the macro the formatting is like the table but you cant sort and filter. you have to first clear the formats and then drag the table range down to cover cover the copied data. from there you can use like normal. this is a good starting point.