I have at least 7 different excel files which have the detail of the entire month, e.g. total amount, # of counts claim paid, # of days, etc.. I need to gather all these information from all the 7 different excel files to one file where the summary (has 4 different tabs with the information from other excel files, which I manually update every month) of all the different payers is updated to present to board..
Right now, the work is getting duplicated.. To open all 7 excel files n manually type in all the numbers is very difficult and time consuming. This work is done on monthly basis.
I was wondering if there is any macro or any other formula to be used to reduce this work.

If any one of you can help me, I will really appreciate.

Thank you,