Ok so basically what i'm doing is creating an inventory system, for around 100 products, but their subdivided. i.e. one area is simply boxes...so i'll just talk about that for now...

I have several different sizes of boxes....and i've got it setup so that on one worksheet i have current level of boxes, which changes from day to day based on the level i have, or whenever i check inventory (once a weeK)....but what i'm trying to setup is a worksheet at the very end so that when i hit a command button that says compile, it compiles all of the info for that day onto a hidden worksheet, i.e. "data entry" and if possible have this run once a week...one guy suggested user forms, but i dunno...

please let me know...thanks so much