Copying the same format data from n number of sheets in 1 sheet

sautri Posts 1 Registration date Monday October 27, 2014 Status Member Last seen October 27, 2014 - Oct 27, 2014 at 03:32 AM

Scenario :
I need to monitor a particular type of transactions. For each transaction done I get a automated mail with an attached excel. The excel consists of two rows heading and data (6 columns only). I need to reconcile these multiple sheets with another system where the transactions gets processed.

Requirement :
I will copy paste all the n number of sheets in a folder. Their names can be anything but all are in same format with 2 rows, heading and data.
I want to have a master sheet in the same folder with the same format as of n number of sheets. Where ever i click a refresh button or command button data from all the sheets in that folder gets fetched and stored in this main sheet.