Combine data from multiple excel sheets when data and header is starting from row#8

[naveennandigam]

There are several tabs in my Excel sheet, I have to combine data from three tabss(Flow 1, Flow 2 & Flow 3) but the row header and data is starting from row #8. All  headers are same except for one column(solumn S) which is same as tab name. Can you please help me solve this issue? I have attached sample workbook for your reference

[OTrieger · Accepted solution]

@naveennandigam 

You can use Batch Macro to solve this issue, and of course as this is a xlsx file you an indicate from which row the data starts. Do not need to worry about column S as it will create for you 3 hears for the 3 different names.

[TUSHAR050392]

Hey @naveennandigam My first suggestion will be to go with what @OTrieger  has mentioned but if you are not familiar with batch macro, you can read data from those tabs individually and then union the data. 

[naveennandigam]

Thank you @OTrieger for your response. I could load the data from the tabs, but I couldnt figure out how I set the header to specific row number. Could you please help me?

[naveennandigam]

Spoiler

@OTrieger Please ignore my earlier message, I am able to figure it out. Thank you for your help

[naveennandigam]

Thank you @TUSHAR050392 for your suggestion. There are more than 3 tabs for me to combine, Having a input for each tab and joining them later doesnt work