Hello, I posted this earlier but with insufficient description title. I tried editing/deleting the other post but looks like the option is disabled.

I have data in a worksheet tab in excel by month e.g.

January:
Interest
Dividend
Expense

February
Interest
Dividend
Expense

I want to name each area say A5:A15=January, A20:A30 = February

In another worksheet, I want to refer to the 4th cell in my range, or add 3 cells together in my range say 5th, 6th & 7th cells. Is it possible to do that? what would the formula be?
I tried January1 and it gave me a Name? error.

Thanks for your help!