What are you doing with the sandpaper?
If it's woodworking: 80, 120, 150, 220, 320, 400 will do almost everything.
If you want to work up to a mirror finish on paint or metal you'll need grits up to about 2000.
If you're sanding metal then it's almost always advisable to use wet/dry...