Hello
In the worksheet called "home page" of my workbook I enter a name in a cell B4. Below that I have a command button. When clicked it creates a copy of 3 different template worksheets and adds the contents of cell B4 to the new worksheet names. This is for customer orders, quotes, and invoicing. So the new customer name goes in cell B4 and 3 unique worksheets are created. This name from cell B4 also gets copied into a cell in one of the 3 new worksheets called "Orders". Once the order details are filled in on the "orders" worksheet I have another command button in that worksheet that populates another worksheet which tallies yearly totals etc. Each new order populates 5 cells in a row on the yearly totals worksheet. The first cell it populates is the customer name which is what I originally entered in worksheet "home page" in cell B4 and was then copied to the orders worksheet as stated earlier. Can anyone help me with some code so that when I click on the cell with the customer name it in the yearly totals worksheet it takes me to the unique "Orders" worksheet from where this row of cells was copied. Sorry to be so long winded. Any help would be very much appreciated!!!