Connect 2 sheets , do manipulations depending on selection from drop down box

You can use VLOOKUP() to bring over information from a row-based database. If you select a value in a cell using a drop down, that value can be searched in your other sheet with VLOOKUP().

I want to be able to put over 100 different numbers (not at the same time) all on sheet1 A1 to direct to there own sheet.

Each individual number will go to a different sheet(only 1 number per sheet)

Please help

Not sure what this means.