How to merge data from different Excels

Hello,
My name is samar.

I have a master sheet which cakculates all oaraneters for my team . To calculate this some raw data is needed . I had worksheet in master tracker named raw data .

Raw data is also circulated to each one of my team member to fill there own raw data . I want to merge all my 10 members data to be merged in raw data worksheet of master tracker at one go without /with macro .


Please suggest me how to proceed for it .