Need Excel help (filtering large data file)

I'm looking for an Excel expert to do a few things to my spreadsheet, and to explain to me how you did it (so I can learn). Note: I use Excel for Mac (version 16.6.7) I have a large Excel file (~7 mbs, ~74,000 rows). The file contains many different web page URLs, along with SEO metrics (e.g. domain rating, organic traffic, etc) for each URL. I need help doing these three things with the file: 1) Filtering the master sheet by criteria for two columns, then automatically transferring the filtered data into a second (new) sheet 2) From the second sheet, automatically copying and pasting rows that contain specific data (unique instances of URLs) into another (third) sheet 3) In the third sheet, automatically removing characters from cells (specifically, removing the web page extension from each URL, so only the root domain URL is left). I would like the freelancer I hire to do two things: (1) do the work in my Excel file (if that would include writing macros to do the work, that would be fine); and (2) tell me (or show me by recording a screencast) how you did the work, so I can do it myself on other sheets. I can share the spreadsheet and a quick video showing exactly what I want done. PM me if you're interested. I'm willing to pay a good fee to an Excel expert who can get this done AND explain to me how they did it. Interested bidders MUST briefly explain what makes them an Excel expert.