Forming different lists from drop down

[johns99]

I'm currently working on a spreadsheet that is based on calculations from the below list of numbers. I named this spreadsheet "Version 1". Is there anyway to create a drop down that would plug these numbers in when I pick Version 1? I would like to create other versions without having to create several lists, so when they are selected in the dropdown they automatically populate.
[TABLE="width: 213"]
<TBODY>[TR]
[TD]Version 1</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Above</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]0.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Above</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]0.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Above</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD]Lump Sum</SPAN>[/TD]
[/TR]
[TR]
[TD]Above</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]Lump Sum</SPAN>[/TD]
[/TR]
[TR]
[TD]Above</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD]Lump Sum</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 3</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]0.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 3</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]0.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 3</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD]1.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 3</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]2.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 3</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD]2.5%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 2</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]0.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 2</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]0.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 2</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD]3.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 2</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]4.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 2</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD]5.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 1</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]0.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 1</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]1.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 1</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD]3.5%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 1</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]5.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Zone 1</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD]7.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Below</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]0.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Below</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]1.5%</SPAN>[/TD]
[/TR]
[TR]
[TD]Below</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD]5.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Below</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]7.0%</SPAN>[/TD]
[/TR]
[TR]
[TD]Below</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD]10.0%</SPAN>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>[/TABLE]