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

Attach a sample workbook demonstrating visually what you're talking about and show us manually what you're trying to automate.

1. Put the numbers on Sheet 1, say from cell A1 tp A100
2. In sheet2, in say cell A1 (or wherever you like) put =Sheet1!A1
3. In sheet2, in say cell A1 (or wherever you like) put =Sheet1!A2
4. In sheet2, in say cell A1 (or wherever you like) put =Sheet1!A3
5. In sheet2, in say cell A1 (or wherever you like) put =Sheet1!A4
etc etc.
Crude, and manual, but that'll work.
If you want to do it without entering the "=Sheet1!A4" formula in 100 sheets you would probably need a macro which takes a bit more work and understanding and might be outside of your level (and so more trouble than its worth).
Perhaps the above would suffice?