Automate and Merge data from different sheets using text and Check boxes.

Hello, I am new to excel and been working on a project that will automate and merge Text/Data from provided data from below sheets (tabs) using text cells and Checkboxes and show a list of all options.

There will be 2 sections of check boxes, material options data check box and a texture filter check box.
1st would be the material option check box , which i want each check box to list all material options that can be found in each sheet (tabs) ; & the 2nd sets of checkboxes will be used as a filter that will show what texture options are checked.

Lastly, I would like an automated list in the Main Sheet to show all the Sku options that are available (checked checkboxes) and a merged detail description next to Sku.

Since I am new to this forum site, i tried uploading a test copy of my excel work with 3 images to help with what i am trying to describe....

I am not looking for someone to do my work for me but i would like to know how would i go about getting to my end results and/or step by step instruction on what to do next?