Can I "link" different spreadsheets together and make them "communicate"?

i am new to excel but hoping to get a quick answer to my question as I am having trouble finding this on the web.

i have Spreadsheet A where new hires get added to a list by someone else. This include their name, division, email, etc.

I manage education and compliance in Spreadsheet B which includes me having to manually go through spreadsheet A and pulling all the info over.

other than this inconvenience, the trouble is the person managing spreadsheet A deletes these people from her spreadsheet after she is done with their on boarding process so if i dont catch it, its a pain in the ass for me to get that info lol.

is there a way for me to have my spreadsheet get updated when she updates hers, but not have that information deleted if she were to delete something from it?