Daleyman tried to help with this, but I couldn`t get the info to him, I will try explaining again. Every day I drag a new sheet over for my production report. I would like all my number totals to go to my sub totals on the new sheet, but I can`t use a sheet # because it would change every day. I may need prozac over this! Thanks