Pull data within the work sheet and save as master sheet with pulled sheet name.

[amar.kshirsagar]

Hi All,

Require your help again.

I want to pull data within the worksheet and save as new sheet in a same i.e. master sheet.

Scenario -

Excel having 4 sheets, with same column, but row count will be different in sheet1 it will 400 rows, sheet2 may be 1000 rows, and so on.

I want pull all 4 sheets data to new one. Starts pull from column "A" and paste in master sheet from "B" and so on.

In a column "A" for each row require sheet name. From where data is pulled

I think I explained very well, but still I am attaching sample file which was done manually for your reference.

Regret for inconvenience if not explained well, so please go through attached file.

Regards

Amar K