Hi Guys ,
I have 50+ locations .The engineers from respective locations send
excel sheets every week .
what I do is pull data manually from each sheet and make a
consolidated report.

Is there any way where in a MACRO pulls data from all these sheets one
by one ,depending upon what cell/row range we specify for the target
excel sheet and appends in the active worksheet.

Any help would be great.

Thanks
Chinmay