So my file has 4 different sheets; "Bid Tab", "Internal Budget", "Continuation Sheet", and "Allowance & Change Order". Currently the bid tab has room for 5 bidders (columns D-H), and when the winning bidder is selected we put their numbers in column C and then the rest of the sheets are filled with their information.

I am trying to figure out a way to eliminate the need for column C and use check boxes above each bidder so that when it is checked it will fill out the other sheets, obviously you would not be able to have two checked at one time.

Not sure where to start as I have never done something like this.