Creating Multiple Tables Using Loop in VBA. I still want to add new sheets and add

[p45cal]

there are columns on the last table that I need merged

Your file has an extra sheet new table, but no indication of what you want merged, nor any new code. It stumps me that you create a new table AND then want to merge columns, why not create a single column to hold the information you want in the first place?