Linking other cells from drop down list

Hello,

SO my problem is based more or less in how I can link different cells based on the drop down list I got.

Basically. I made a list from the number of sheets I got so far (need to create several sheets as I go on with-in the document so it is a dynamic document) and in different sheets I get different values. How can I, from a drop down list, get automatically designated cell fill?

SO in the sheet "V042013", I want to a dropdown list linked to the sheet "Index". If I select a number from the list I want it to autocomplete the Saldi in "V042013" from the respectif sheet.

Is that possible? If it only works with macro so be it.



Thanks alot in advance!!

Hello thanks for the welcome.

I did a little explanation through a picture I put together of what I want to achieve attached to this reply.

I hope this clarifys it a little bit also attached the excel file.

Thanks in advance.

Regards,
Odair