Reporting on data received in same worksheet format, in different workbooks, at regular intervals

[Excel Chimp]

To elaborate on the title, I do reporting in which the same format worksheet is emailed to me (as separate excel workbooks) from several users. It is my responsibility to summarize this data from each user into a financial report on a monthly basis. I'm trying to avoid manual data entry and automate to the extent possible, without delving into VBA.


I'm looking for guidance of a more general nature. How does the community approach this issue? At this stage, I don't know what I don't know. Resources you could point me to would be great, as would a general direction to pursue.
Thanks!