Excel VB

Could anyone help me how to program in excel using the variables.

I have done a coding for a set of data's in a sheet to copy and display in
the Index sheet.

Similarly i have to do the same for the remaining 46 sheets.

Could anyone help me how to do that with a single program, by changing the
sheet name with reference to the dropdown box value which i used to select
these 46 sheets.

The data range in all the sheets are same.