How can I use Google Sheets to separate data by a specific value? or What's the best way to separate

Not sure if this helps, but you can also use IMPORTRANGE() to pull split data into separate sheets entirely.

Like, have one master sheet and then smaller sheets that only pull in rows with "Region X" or whatever.

Might be overkill, but it keeps things organized long-term.