Using concatenate to define cell references in formula for simplification. Excel 2007

Hello,

I am creating a spreadsheet that collects productivity data. I want to be able to add date input daily, 1 day per sheet and have that data collected onto a single sheet for the month. At the moment, it seems like it's very time consuming to create the links from day 1, and then from day 2, and so on.

I'm wondering if there is any way to simplify this process by using concatenate?

For instance, for the first day, I'd be getting info from "='1'!B35", then "='1'!C35", "='1'!C35", "='1'!D35", etc. And then repeating for day 2. Is there any way to simplify this? For the row that represents each day, I can simply copy the formula across the row and the formulas are copied and adjusted. I havent' figured out a way for the formulas to auto-adjust across sheets the same way they do across rows and columns incrementally.


Any help would be appreciated.

---------- Post added at 10:16 AM ---------- Previous post was at 09:55 AM ----------

I figured it out.

Column A has the dates listed by day number.
Row 1, to be hidden, will include the Column number for referencing purposes. C$1
35 is the row on each daily sheet that contains the totals for each day of each category(column).
2 was chosen because I want the data to come exclusively from row 35. It appears to work exactly as intended. This will come in handy in future.

=INDIRECT(ADDRESS(35,C$1,2,,$A5))

Now can I get any suggestions on tags to use to make this thread easier to search for anyone who may have the same question?

Thanks. I sometimes have difficulty deciding on a subject in emails even.