First off, I appreciated both of you for the help. It's very much appreciated.
My ultimate goal is to create a weekly inventory workbook. My idea is to have the current inventory in one column (B5:B21) and the previous week's in another (C5:C21). When I have it create a new worksheet, it will move the data from the current inventory over to the previous inventory column on the new worksheet and then zero out the current inventory column in the new worksheet. Inventory is done every Monday hence the 7 days. The sheet names would be the named the date the inventory was taken (every Monday). Sorry if I'm not explaining it very well.