Good day!

Disclaimer: I'm not exactly an excel expert so I don't know which terminology to use for some instances.

I'm trying to create a summary worksheet referencing 31 other worksheets (every day of the month).

So when I 'link' a cell in the summary worksheet to, let's say, another cell in worksheet titled '1', it appears in the summary worksheet like this:

='1'!$J$6

Is there a way when I drag is down to the next cell it will appear like this?

='2'!$J$6

Thank you!