Updating a row in Excel based on data entered in a cell in that row

Hello, I have a spreadsheet where one worksheet has a table (table 1) full of data about different projects (which are numbered and separated by row). I have another worksheet with a table (table 2) to allocate different people to those projects. What I usually have to do is duplicate the data through copying and pasting cells from table 1 to table 2. 

What I would like to do is enter the project number into a row in table 2 and for the data in table 1 to populate the row in table 2 - is this possible through Excel or is this more of an automation question?