Report auto populator

Further Details - I have the first part of VBA working so can send you a s/sheet. However I need to make the data pull from the analysis sheet into the report sheet dependent on a variable category, category being selected from a drop down. The logic to define what needs to be pulled into the report is complete, so I just need to interrogate 4 different columns for 4 different categories in the drop down and if "1" is in that column, write the data into the report. Details. If "Open - Late to Baseline" is selected in Report sheet cell N26, then if a "1" is present in Analysis sheet column AA, then the report needs to pull the relevant data from the Analysis sheet row containing the "1" (as per the the current report - you can see the details in the existing VBA). However, if Report sheet cell N26 is changed to "Open Task Look Ahead", then the code needs to look for a "1" in Analysis sheet column AF and pull in the relevant data. Likewise, if Report Sheet cell N26 is changed to "All Tasks" then the code needs to look for a "1" in Analysis sheet column AJ and finally if N26 is changed to "Tasks in Backlog" then the code needs to look for a "1" in column AO. Therefore as the user selects the category from the drop down, the relevant data is presented to them in the report. File attached.