Automatically update master excel sheet with information from other excel sheets?

So, I'm setting up an accounting book. There's a master sheet that needs to pull from the other sheets that are made. The problem is, with each new sheet that is made, I have to update the formulas on the master. I would like that if I made a new sheet, the master would automatically pull from it.

Example:

Master pulls renter fee info from May 3rd, May 7th

I create sheet (May 15th)

Master pulls renter info from May 3rd, May 7th, May 15th

Is this possible? Or is there a better way to do this?

Being a database guy, this would work better in Access, but if you must stay in Excel..
Try recording a macro, to copy the new sheet to the MASTER workbook.