Consolidate multiple tabs with same format to one master with column added for tab name

[kelbrod]

Need to consolidate about 40 tabs to one master tab with same format columns A-G and add a column for tab name column H.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...format-tab-name-added-column.html#post5257282

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).