I have a workbook with 5 worksheets. Sheet 1 is a summary of data on sheets
2-5.

Sheet 1 will always be named "summary", but the names of sheets 2-5 will
change monthly.

How can I "generically" reference sheets 2-5 so I don't have to change the
formulas on my summary sheet each month?

In other words, if the name of sheet 2 is "FLX_75" this month and next month
it is "FLX_79", how do I write the formula to pull data from the correct
worksheet without having to edit it each month. The formula will always
reference the same CELLS on these worksheets, so I only need the changing
worksheet.

Thanks!