VBA Copy Paste with Direct Cell links

[WWII_Buff]

Here is what I am trying to do.


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


#1 , I'd like to bring over the header from the 1st worksheet as well, but not the subsequent worksheets.
#2 , I'd like to skip blank rows on all sheets
#3 , Instead of copy paste special value, I need the "Master" tab data to directly link to the specific worksheet e.g.

FormulaR1C1 = "='27900'!R[3]C[-1]"

where 27900 = a sheet name


Thank you all so much!

 

[offthelip]

I hope you have got a line feed carriage return after the sub test (). Your last post didn't. I suggest going back to the version that tested and do it a step at a time and check it compiles.

 

[WWII_Buff]

I am not sure I understand what you mean.
Question is - does the code I posted look like it should run as is?

I do appreciate the help greatly.

 

[WWII_Buff]

I am confused as to why it works with just "2018_EXP" and "Master" as exclusions. But when I tell it to exclude 6 other tabs it doesn't run.

 

[WWII_Buff]

@offthelip It works! (...as if you didn't know already)

Not sure what the issue was - I moved all the tabs to a new workbook and PRESTO! Must had had some crud mucking up your magic!

Thank you.

I wish there was a way to reward you bro! The way doctors keep count of lives they save, you geniuses should keep count of careers you save LOL!

 

[offthelip]

Glad to be of help.