Excel Speadsheet

We currently have 4 Tabs, all mirrored the same, named. We are trying on the altogether sheet, that if Column A is selected as Yes, then that information will automatically go onto the altogether tab. Call if easier, please? Thank you.