What would it take to have a cell that does a Vlookup based on the cell that's currently clicked on?

Apparently the sheet already crashes here and there so I suppose the more elegant the solution the better.

We have these big meetings where we will run through hundreds of projects and their costs. It's my job to monitor how a different variable is getting managed if a project gets moved in or out. Everyone else is really only concerned with the money,

Currently my steps would be: Look at the sheet the presenter is showing, open a sheet on my laptop, manually type the project number in a search, see the variable assignment, then I check another sheet to see how that variable is performing.

Ideal setup would be: As the presenter clicks on a project, in the corner of his screen it looks up the project and shows the variable. Now I can just have my variable performance sheet up on my laptop and respond quickly since the info is already looked up and on his screen.

I used to be pretty good with VBA, though haven't touched in 5-10 years - open to those types of solutions as well.