Cell linking - format & grouping

Options

I am trying to link multiple columns from one sheet to another, the information has populated however I have groupings (multiple parent rows and color cording) on the source sheet that I would like pulled into the second sheet. Is there a way to do this?

Answers