Drop down to change sheets in excel

[missskmurray]

Hello,

I am working on a monthly budgeting sheet and I am having a nightmare with it. I have a large merged cell on all of the sheets from B1-F1 and B1-B13. I have got a drop down list with the months and separate sheets for each month. How can I make it so this drop down list changes to the corresponding months sheet?

 

[awoohaw]

you can probably do this in one cell with VBA. But here is using the drop down to update a hyperlink just below the drop down cell.
Copy it on each worksheet, but first list all your worksheet names in the list. I tried to use a named range and it would not work. I also just tried a regular range address (but maybe you can fiddle with it more.)

Mr excel questions 58.xlsm
	A	B	C
1
2		"misskmurray1"
3		Go to "misskmurray1" > A1
4
misskmurray3

Cell Formulas
Range	Formula
B3	B3	=HYPERLINK("[Mr excel questions 58.xlsm]"& B2,"Go to "& B2 & " > A1")

Cells with Data Validation
Cell	Allow	Criteria
B2	List	"misskmurray1","misskmurray2","misskmurray3"