I wish to get the macro codes for a Drop Down List spredsheet

[MacroMaster]

I want a main sheet and 3 sub-sheets.
All sheets have 3 columns

[TABLE="align: center"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Number
[/TD]
[TD]Type
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]


I want them to sort by Date first, Then Number.
The type cells will have ‘drop down lists’ on them; 1, 2 and 3 corresponding to the three sub-sheets.
I would like the data to be automatically updated on all the sheets, and in the correct order, when a value is changed in any of the boxes. I would like the other values to all be constantly be updated when changed on any sheet.
I would also like a single ‘drop down lists’ cell in all the sheets, which when the type is selected the sheet will open up automatically (0 for main, 1 for sub-sheet 1, etc).