Auto-populate specific data from one sheet to another

I'm interested in auto-populating empty cells in rows that match an exact ID number. I handle failure analysis activities in R&D at my company and there are many different excel sheets that are owned by different individuals and each have various types of useful information about failure modes, locations, root causes, tracking numbers, etc. There is a shared workbook that needs to be updated for feedback to management and I am trying to create a way for it to update itself so that I don't have to waste time copying and pasting information all the time. Ideally we need a database, but it's almost impossible to get new software approved through IT in under a year. In addition, R&D is only handling FA temporarily, so spreadsheets work for now.

I only handle failures that are assigned to my name. I want to use some type of VLOOKUP to find the row of a specific tracking number and then have it fill in other cells from that row with data that is present in another worksheet in the same workbook which I've already setup to query data from my own workbook. Any ideas? I'm hoping the response won't be a visual basic solution, but if so I'll have to learn how to use visual basic and where to type the code into my workbook.

Anyone have any ideas?

Thanks,
Adrian