I have a spreadsheet that contain data by category. Example:

Foundation ----------- cost 1 -----------cost 2
Foundation - guy 1 ---- $100 ---------- $150
Foundation - guy 2 ---- $120 ---------- $160 -- X
Foundation - guy 3 --- $130 ---------- $190

If I put an "X" or maybe "highlight" on column Foundation - guy2 for
example, I would like to populate his information to a different sheet.

Do you know how to go about it?