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.
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.