I dont have much experience programming with excel and was wondering if this is possible, and if so how?

I have several (3000+) lists. They are set up like a table with the first line being the headings, and the rest of the lines being objects. What i want is to filter these objects based on one of their values and then look at another value (true/false) and take the highest of a third value for all true and the lowest of that same third value for false... I can import them one at a time but do all of this by hand but it would take like 45 years, so i was wondering if there was a way to do any of this with a macro or via c# or something

Thanks for any help