Originally Posted by NoSparks

I don't know the purpose or ultimate goal for this but my first inclination would be to use a macro rather than formulas.
With the exception of A2 being blank, it appears you're wanting the columns of your second sheet to be what filtering for those columns in the first sheet would be.