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

Registration date
Monday October 27, 2014
Last seen
October 27, 2014

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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!