How To Get Column A & B Data From Tab 1 To Auto-Fill Into Subsequent Tabs

Hi, Ben! Bennadeau 

Thank you for your quick reply! I entered the formula you provided, and it pulled the existing project numbers and names into the field perfectly. However, it doesn't seem to update the subsequent tabs when I add a new row/record to the table in the "Project Setup" tab, unless I manually expand the table in the subsequent tab. It also isn't allowing me to sort the tables on any tab other than "Project Setup" tab (aka Tab 1). On Tab 2 "Client + Location Demographics" I entered some dummy data to the "Community" column to test sorting, but the data disconnected from its original row (see attachment). Column A & B stay rigid but the rest of the data from the table moves. This won't work because I'll have mismatched data if someone comes in and tries to sort it another way. Any other ideas?