MYJOB: AUTO-COPY date from spreadsheets, if HEADINGS match rather than copy/pasting

firstly i have no experience with macro much or vba so i need a formula i guess.
we have many spreadsheets; now rather than copy pasting.. surely if the headings match.. then a formula should be able to copy the data underneath into the master sheet automatically or with less effort with index/match, hlookup or something formula...

would save so much bloody time...!

help? anyone? can't be that hard...