If you want to use values from one worksheet to another, you would need to use a reference to the worksheet.
Add Worksheet name and ” !” Mark in front of referenced cell to accomplish worksheet referencing. For Example, Formula =SUM(A1,Sheet1!A1) will add cell A1 from current Worksheet and cell A1 from Sheet1.
