I want to move entire rows to a new tab that contains certain text. How do I set this up without having to copy/paste all the rows containing the certain text?

Create a report sheet instead, which reads and displays data from your original data sheet! As additional bonus, on report sheet you can have one or several fields, where user can enter/select filter conditions for report - so essentially you get different report for every set of conditions.

Known problem How to Move Row to Another Sheet Based On Cell Value in Excel? - Spreadsheet Planet

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I think it says you have Excel 2021, so you might have access to the FILTER function.

I got to play with this last year to do the same sort of thing. It pulls info to various tabs based on whether the text in the first column contains a specific letter pertaining to that division of the company. From there I specified which columns to copy and in which order. I'm not sure I used it recently enough to do without looking up the steps, but:

FILTER function