creating a summary sheet a simple query

[rajeshmanjrekar]

I have enclosed sample sheet where i have manually pulled data from sheet A, B, C...etc.

I have a sheet that has 350 excel sheet. I have to create a summary sheet in the sheet called summary.

I do not want to keep on changing the sheet name in the summary sheet for the formulas, I want to use the name in column A to pull that data from the various excel sheets.

Thank you in advance.

Regards,

Rajesh

 

[pecoflyer]

Try this addin
or
this code

 

[rajeshmanjrekar]

Try this addin
or
this code

Thank you for the reply, but my data is all over the place. I think this add-in is for standard data which is more in the form of a table.

Could you kindly suggest something else.