create a button to link

[Jeannette]

I would like to have two worksheet in the same workbook. When I click in the
cell name "Manufacture" that creates a link to the 2 sheet where all Point of
contacts. phone numbers, address, emails,

 

[Andy Smith]

Select the "Manufacture" cell, and then do Insert / Hyperlink, or Ctrl-K. On
the Insert Hyperlink dialog box, choose Place in This Document on the left,
and you'll see all worksheets and named ranges in the middle. Choose what
you want, then click OK.