No need for code. Try the following:
1) Next to each vendor name, type in the next cell "Vendor Profile"
2) Make a new sheet  with that profile on, and name the sheet something
descriptive.
3) Back in Index sheet (Good name for this sheet, by the way), right click
on cell, select Hyperlink, and refer to a location in the workbook (in this
case, cell A1 on the Vendor Profile sheet you created.)
4) Good practice is to create  a link back to the Index sheet the same way.
5) Making it look pretty: Remove grid lines on the Index sheet, and space
things out to fill a decent sized screen (not larger fonts, just a few blank
lines between entries). Design for 800x600 if you can, else 1024x768. Not
everyone has 24" widescreen monitors.