VBA Help - Copy Multiple worksheets to one summary with a twist...

[WWII_Buff]

Hey guys - So here is what I am trying to do:

I have 50+ worksheets with identical headers but different row lengths. Rows "A4:BA4" are the headers, A5:BA... is all data. I would like to combine into one worksheet "Upload tab".

#1 , I'd like to bring over the header from the 1st worksheet as well, but not the subsequent worksheets.
#2 , I'd also like to insert the contents of column B2 from each worksheet into column A of the "upload tab".
#3 , I'd like to skip blank columns.

Thank you guys!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...e-sheet-but-copy-header-once.html#post5077487

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).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.