I have book with two tabs in it.

TAB 1
On the one tab I am using columns A - AI. I have a set of conditional statements in the AI column that say if certain criteria is met in the columns in the middle then display an "X" showing me that the row is finished being evaluated.

TAB 2
On my second page is where I usually copy columns F, R, X and AA of the previous page that have the "X" in column AI to consolidate my information.


I wanted to know if it's possible to do this programatically where one could write a worksheet function that returns those values from TAB 1 on columns F, R, X and AA where there is an "X" value in the AI column. Does that make sense?