Hi All,

I have got a data which is regularly updated by my colleagues in Excel file
which is a shared file saved in a share drive.

There are around 35 to 40 worksheet. One worksheet for each employees. It
has 9 columns. I want a macro which will import data entered in all these 35
to 40 worksheet into one master worksheet of the same or another file. Where
in I can prepare some pivot tables to do some analysis.

Is it possible to get all the data from these many worksheet into one master
worksheet by click of a button.

Cheers,
Mandeep