Consolidating multiple sheets

[jatins1986]

Hi,

I have 10 tabs with data. All the tabs have the same number of rows (A to AI). But different number of columns.
I need to use a macro to copy data from all the tabs into a single tab.
Kindly help

Thanks

[stnkynts]

Submit your workbook, with any sensitive information removed, which clearly shows what you want the summary/consolidated sheet to look like.