Populating rows with linked info

if i type one datas name, can it populate the rest of the info in the row?

That all depends. It is possible to do, and do quite easily IF the name you type is unique. Excel has some wonderful tools for taking clearly identified data from a table and using it to populate fields elsewhere. One of the earliest tools, and most popular now for decades, is the VLOOKUP function. There are others that have come along as spreadsheets have developed the functions to be more flexible and more powerful.

But that first point is crucial--the name (or identifier) you type as the basis for retrieving the rest of the info on the row needs to be unique if you really want just the information on that one row. This is why such things as employee IDs (or customer IDs, etc) are handy.

If your data file is not proprietary or confidential, would you be willing to post a copy of the spreadsheet on OneDrive or GoogleDrive and paste a link here granting edit access?