I am looking to write a macro so that when a user inputs items in a cell and <enter> the user will be taken to a different sheet. For example: Use enters 2 in B2 then they will be taken to Sheet2, If 3 in B2 then Sheet3, anything else entered in B2 the user would be taken to Sheet4.