Autofill Sheet information through excel/drop down menu

Hello,

I'm wondering how to create an Autofill system for out sheet information Per Project by using information tables:

 

I want to make a row/record in a table and automatically autofill the sheet information by selecting the project in a dropdown menu through custom properties

 

For example:

No.          Project name        Project number       Project manager      Sales advisor           Lead technician    

1                Grill Bar                202504.001              Dave                        Jack                        Kevin 

 2               Sport canteen      202504.002               Jamal                      Hoff                         Mary 

 3               High School         202504.003               Dave                       Hoff                         Robin

 

And by selecting High School in a dropdown menu at Custom Properties / Tab builder it autofills the rest of the information

 

currently I have to insert this information by hand in the properties builder tab for all my drawings, but i guess there could be an easier way.

 

If anyone has another/better idea i would love to hear it as well.

 

Regards,

Kevin