Making a reference point for my macro

I am trying to set up a macro that combines different sheets in a workbook. This number of sheets will change each time so currently, I have to go back in and change the number each month.

For x = 1 To 27
some months it will be
For x = 1 To 30
etc.

I was trying to make a reference point in the workbook that will change the code depending on what number is in that reference point (so humans don't mess up my macro )

The idea being something like this:

For x = 1 To Sheets("the reference sheet") Range( "the number relevant for that months report)

Any advice?

Duh! Thanks.

I am still learning the code and just getting really into Macro's.

Thanks again for your help!