Copy Multiple Worksheets into new columns

[Edwardanson]

Hey thank you so much for your help i just ran the code then and its giving me "Run-time error '91': object variable or with block variable not set" and as i am still new to excel code i am struggling to fix it when i click debug it highlights the second line "thisWB.Activate" however i really dont know what im looking at enough to even start trying to fix it.
So to make it clear what i want.
In sheet one of the Attached file it has months jan-dec i would like a macro or way to move all the data from 12 separate excel files into sheet one of this spread sheet.

Below is code that i have taken from the internet and need help fixing/ tailoring it to my situation

Please Login or Register  to view this content.

[protonLeah]

The line:
xlsCommonSheet = Range("Sheet_Name_to_Combine")
is causing the first error. "Sheet_Name_to_Combine" is not found anywhere else in your code.
Same for: startColumn