Copying Data from One Excel Workbook To Another

Hello,

Newbie here, on my organization my reportees are sending me a report on a daily basis, the pain is to collate each of these sheets onto 1 and do the final dashboard reporting. I would like to know if there is any option where i can use VBA to copy entire contents from one workbook to another Master work book on a button click ideally.