How do I use macros in Excel to check specific items in a checklist on one sheet copy over to another sheet

I have a checklist set up on one sheet with ActiveX check boxes next to each row. I want to be able to check any number of those items (which is dependent on a number of factors and will change frequently), click a button, and have them populate on another sheet where I have created a form. Ideally, I'd like to only copy the cell to the right of each checked box.

I've found examples close to what I'm describing, but I've never done anything with macros before so I really have no idea where I'm going wrong here. I cant even manage to rename the check boxes to something that makes sense because I get errors every time.

If anyone knows how to set up something like this in excel it would be very helpful. I'm trying to set this up for work to make this task easier on myself, but again, I'm new to macros and have no idea what I'm doing.

Thanks in advance.