Connect values from sheets to a drop-down list

@Glenn Kennedy, @davesexcel

Thanks for the tip, have deleted some sheets and just left sheet 1-2. I've highlighted the cell in "value generator" which I use when replacing the sheet name in use. Right now it's sheet1 so the "value generator" sheet is gathering all the data i want from "sheet1". As I mentioned I use the ctrl+b to change the name of the sheet so the value's I wish to work with are changed, so the only thing I would like is to stop using the ctrl+b to replace the values and instead have a drop-list where I choose which sheet I want my "value generator" to use.