How do I use check boxes to join multiple possible text options into a new worksheet?

[Galphanore]

What I have right now is a spreadsheet with 8 separate worksheets. Each worksheet has a list of things in it that includes six fields. The first two are check boxes, the remaining four are text. I hope that makes sense. So, what I'm trying to do is create a new worksheet that only contains the things that were checked in the other sheets. So, if someone checks box 1 in row 1 then Text1-Text3 for that row should show up on the new worksheet, and if they check box 2 in row 1 then Text4 for that row should also show up. It shouldn't be possible for them to check something in Check2 without checking the corresponding Check1. I can't figure out how to get it to work though.

I'm not overly familiar with excel so I haven't actually been able to even figure out how to get A true/false field to "copy", so to speak, data into another table. I've attached a version of what I have using test data. Can any of you give me some advice ether on where to go to learn what to do or how to do what I'm looking to do?

[ChemistB]

Nevermind, reread the first post.

[Galphanore]

Checkbox 1 should bring 1, 2 and 3 and if both Checkbox 1 and Checkbox 2 are checked then 1,2,3 and 4 come across. Nothing should happen if just Checkbox 2 is checked or, preferably, checkbox 2 should uncheck if the corresponding Checkbox 1 isn't checked.

Nevermind, reread the first post.

No problem I wasn't sure if the way I worded it made sense in the first post.

[Galphanore]

Heck, I'd be happy if I could figure out how to get it to copy one text box to a new worksheet when I put a check mark in.

[martindwilson]

maybe something like this ive only done the first six check boxes on each sheet for demo purposes you need to link the rest to sheet one like the others

[Galphanore]

Excellent! Thank you so much, that's exactly what I was looking for.