Two validations: first choose the sheet (1-5), then choose the option

Hi there, I'm quite new to Excel and am trying to make a project. The project has let's say 6 sheets. Now I'm in the sixt sheet and I would like to:

In cell A1 I want to pick sheet number 1, 2, 3, 4 or 5, with that nice little window I can get through "validation".
In cell A2 I would like to get the option to pick cell A1-A50 from sheet 1, 2, 3, 4 or 5 according to the sheet I picked in A1.

For example - sheet 3 is called "money", and in this sheet there are cells A1 till A50 filled in with a number from 1 dollar to 50 dollars. When I'm in sheet 6 I want to pick in cell A1 the sheet number 3 - "money", and in A2 choose from A1-A50 from the money sheet.

I hope I'm understandable and I'd appreciate any suggestions a lot. Thanks! Tom

Hi, does anybody know? please

Hi Glenn, thanks a lot for your response, I really appreciate it. I'm sorry for the not so clear explanation, but as I looked now, your understood it very well :-) Thanks! I'm now trying to get it right, and I'll write here as soon as I manage (or don't manage) to make it work..