Yes, there are different sandpaper uses for wood and metal, if you use one sandpaper on both materials this creates not best results as you expect.
It only depends on grit of sandpaper; if you want to use on stripping, bulk-sanding ,reshaping then the coarse grits are best;
medium grits are for smoothing wood; and the finer grits are for sanding metal in which you also be use removing Rust With Sandpaper and polishing finishes.
If you want complete info about sandpaper use then you must touch the Sandpaper grit guide that can clear your data.