How to Copy Formulas From Different Worksheets

I am trying to simplify the inventory sheets we are using to make the process easier.   In an excel file, I will have one sheet for each date we take inventory.  We create the sheet each week that...