How do I save daily entered data from a spreadsheet and pull it to another by date?

At work they want me to start tracking inventory (work completed) for the entire department by type. I created a spreadsheet that data can be entered into. My issue is: When they enter the data each day, I need it to be saved into another spreadsheet by date...then my manager wants a separate spreadsheet to pull the totals from the data entered in the original sheet. I've created both spreadsheets (attached) and linked the cells so the totals from one sheet appears in the other. I dont how to get the second spreadsheet to pull in data from whatever date she chooses to view.

Originally Posted by msexcelathome

So Basically you want to enter data in Sheet "Daily Inventory Tracking Form" and based on the date you want a new Sheet to be created with all the data in it??

Is it right?

Yes, the data will be entered from several users with their own access to the "Daily Inventory Tracking Form". I want to be able to pull data for whatever date I choose.