Copy sheets from multiple documents into a single one

Hello,

I'm new here so I don't know if this has been asked before since I don't know what to search for. My issue:

Every month I have to compile final reports for my company. What this means is I have a giant Excel document with many sheets (one for each project) in which I paste data from separate documents but where the sheets have the same names (yet are carefully divided between 3-4 other people/reports). I usually do this manually but I would love to find a Macro to help me out. I should mention I'm on a Mac.

Any help would be greatly appreciated! Thanks!