RE: formulas
Hi Hash, Thanks for the post, Welcome to the forum, in answer to your question, this is quite a simple thing to do, in the sheet (Sheet1) active cell that you wish to have the link, place an equals sign (=) and then change to the sheet (Sheet2) you wish to link to using the tabs at the foot of the workbook and select the cell to be linked.
Press Enter and you will see the data in Sheet1 will be exactly that as in Sheet2.
You can create formulas that link worksheets and even workbooks in the same way. I hope that helps, best regards Pete.