I named 52 multiple sheets with 01-4, 01-11, 01-18,01-25, 02-1. In my spreadsheet I convert these sheet names to dates. Each sheet is identical except for the week date. I want to collect data as the sheets are filled out. Rater than put every sheet name in my formulas, I wanted to define a name range. I found a reference that used an array. I use "define name". Because my sheet names look like numbers or formulas, I get the response to put an apostrophe (' ) before the numbers. I have used every combination I can think of.

How cane I define a name range to use in formulas and still use 01-4, 01-11, 01-18,01-25, 02-1 as sheet names?