Looking for help with three complex formulas

Hello from Australia. I am desperately seeking some assistance with a complex formula. (Complex to me at least) Problem 1: I need the girl's tab (second tab) to bring across limited columns (so o...