I have an excel spreadsheet that has several sheets and different area of those sheets that I am linking to. My problem is when the link is activated, the linked cell starts at the bottom of the page. Now is there a way to link to the cell and have that cell move to the top of the page? This is a spread sheet that will be distributed and it just doesn't seem very user friendly the way the links show up. I hope that makes sense!

Yes, don't link to just a cell, select a larger range of cells and link the range. The links always try to fit the linked area onscreen, so playing with the size of the selected area should get you better results pretty easily.