new macro for opening files

hi guys/gals
got a new problem i know you lot can help with :P,
i have a spreadsheet that i want to take info from a file and dump it in,
there is a few files i use so i was going to use a drop down list to name the file i want the macro to use for example

Please Login or Register  to view this content.

luckily the way the file is saved the only sheet in there will be the same as the file title
i now need to open the file would it be simpily

Please Login or Register  to view this content.

the code i have atm for a little test is

Please Login or Register  to view this content.

but it ant working ( because its S***)
any help would be mint its an ongoing project so am working my way through.
Many thanks
Kieran