Welcome to the community, Robin! :grinning_face_with_big_eyes:
The only way for this to work is for all tables to be in the same base. Airtable currently doesn’t support referencing between bases. With all tables in one base, rolling up the relevant info from each project manager’s table into a master portfolio table should be relatively easy.