Fixing the VBA code

Push.xlsm
Attached is a sample file of what I am looking to accomplish.
On the sheet 'Enter' there is a button control to a VBA macro that allows the information entered into sheet'Enter' to tally onto sheet 'Tally 1'.
Also on sheet 'Enter' cell A10 says SHEET. I would like to enter the sheet name into cell C10 and have the VBA code add the information into the correct sheet. I am at a loss at to how to get the information to the correct sheet.

Please Login or Register  to view this content.

Bob, you are the man. Worked perfectly. Thanks a lot.