Autofilling formulas from multiple worksheets

Hi guys. I am decent with excel, but I am trying to help a fellow employee out at the moment who has very little knowledge of excel. She is doing a sales report summary for the month. Each day of the month has its own worksheet within the Excel workbook, and there is a summary page, which I am helping her with. I am trying to use formulas pull the sales totals for each day and display them on the summary page. There are 10 sales category totals each day, so it would take me a really long time to manually link these all to the summary page. The daily category totals are in the same cell of every worksheet What I'm wondering is:

Is there a way for me to enter the formula for the first day of the month linking it to the category total in the worksheet for the first day of the month, and then somehow autofill it down for the rest of the month so that the formula automatically adjusts? For example: ='1st'!L9, ='2nd'!L9, -'3rd'!L9, ='4th'!L9, etc. so that I (or really my co-worker) doesn't have to manually link each total to the front page.