Using filter with list stored in a column and process data for each filter selection

Hi friends,

I am trying to filter a range "a:o" on column d with different values stored in a column in another sheet. I scroll through that list, use first value as criteria for filter on column d, process the filtered sheet, collect data and store the processed data in a master excel sheet. This I continue till I reach end of the list which I am scrolling. So I change filter criteria with each name in the list and process for each value. How do I use filter with variable criteria stored in a list?

Thank you so much,

Shailesh Tupe