Macro to Export systematically to master spreadsheet

Hi Guys,
I'm quite new to excel macros, a little help would be much appreciated!

I am stuck on this problem: every quarter we receive an excel file with large quantities of data (different sheets but in similar format). I need to select the needed data and transfer it manually to specific locations on our master table (different spreadsheet). Is it possible to create a macro that will automatically transfer the data from one table to another? and how to proceed?

Please help me, thanks a lot!