I'm trying to create a workbook broken down by quarters, each quarter with its own input page. I want a user to be able to enter a 1 to indicate yes to a certain field. Once it is filled out they can then hit a submit button that information would be added to cells in different worksheets within the workbook. I am pretty knew to VBA and don't know how to do this, any help would be appreciated. Sorry if my description didn't make much sense either.