Adding Checkbox to populate info from one sheet to another sheet.

I've created a file that has two sheets, Masterlist and SUMRoadway. The Masterlist has 8733 rows that contain sorted information from lowest to highest numbers.
I'm trying to add check boxes to each row so I can click the appropriate items needed per project and populate the item number in the SUMRoadway sheet starting on row 3 and then consective after that.
Is this possible or am I way off base?
I've been able to get the checkbox loaded and get the info to show in SUMRoadway but not in consective order.

I'm attaching the sheet for ease of reply.

Hi Lenoir,

Is this what you are looking for?

I haven't dragged the formulas all the way down, but you can just copy/paste them down

That is exactly what I've been trying to do. Is there a way to copy those checkboxes so that they go with each row number.
I just attempted to copy the checkboxes down the Column D in my Masterlist and they all continue to point at Row 1?
Meaning when I check one they all highlight.

Hey Lenoir,

Unfortunately not. Excel's checkboxes are a total pain like that. If you want an easier option, you may want to consider Marlett Checkboxes. For a quick run through, check out this page:

http://www.ozgrid.com/VBA/excel-checkbox-tick-cell.htm

If you do decide to go the Marlett route (which I would highly recommend, unless you feel like manually re-targetting 8000+ checkboxes!), just change the formula in cell F1 to

=COUNTIF($D$1:D1,"a") ---> then copy this formula down as far as your list goes.

The rest of the formulas in the other sheet will then work correctly with the Marlett checkboxes

I don't have a great deal of VBA code experience. I've done what posted above and it's working I just want to make sure what I've done is correct.
I first right clicked on my Masterlist sheet and inserted the code number 1 and I changed the range to D1:D8733 and closed the code box.
Then I added =COUNTIF($D$1:D1,"a") to my F column.

I did not actually see any checkboxes showup but it I put an "a" in one of the rows in column D then it shows up on my SUMRoaday sheet.

Is this correct? or is there something that should showup for me to check in Column D?