[Death Row]

I'm making a system about calculating energy usage, for my ICT project, but I've gotten hopelessly stuck on one aspect.

In order to make the project as user friendly as possible, I said they could retrieve data with macros - I've discovered however that this is rather difficult.

So, it works like this
On one sheet, there's a list box, with a load of table names, the user selects a name, and presses a macro button that looks up the table, copies the information, and pastes it onto the current worksheet.

My problem is writing the macro to look up the appropriate table.

I worked out, that the code to looking up a table was

Application.Goto Reference:="_29_03_2011"

and I thought i could simply change the table name in the code to RefersToG12

Application.Goto Reference:=RefersToG12

It simply says the reference is invalid, and I'm utterly confused as to what to do.
Any help would be greatly appreciated.

[Death Row]

I've just thought of a much better way of rephrasing the previous post

In the formula bar in excel, there's a drop down menu, which shows all the named ranges
I just want to implement this drop down menu into a worksheet/Visual Basic Form for the user to use.

I'm pretty sure this is possible with some clever visual basic coding, but if it isn't, please tell me!

Thanls again