Linked workbooks are a database in disguise, so it's time to treat them like one.
The more I connect Excel to the other Microsoft 365 apps I use, the less often I find myself copying, pasting, and retyping.