VBA code for creating a auto generating mastersheet

Hello,

I have a basic Excel workbook that contains many different sheets with the same headers, in which I would like to compile into an auto updating mastersheet. Initially I used data connections, which have been challenging because our the file needs to be accessible to multiple users at one time.

Any advice you have on how to program the master sheet to auto update would be appreciated!