Need help getting a summary tab to pull data from exactly the same cell of other workshee.

Hi, I am new here and, as a bonus, I'm also a relative novice--I hope you'll forgive me if I've missed this answer in previous posts. I did search through them, but I'm couldn't find exactly what I'm looking for (or else I didn't understand the terminology).

I have a basic equipment maintenance file with a worksheet for each piece of equipment. The summary worksheet allows for a quick view of the most recent maintenance action on all equipment. The equipment worksheets are ordered by date with the most recent at the top. When new maintenance is done, the user inserts a new line above the most recent and fills in the information (this is the extent of this user's skills, so I have to work around that).

How can I get the summary page to pull the most recent information? Everything I've tried follows the actual data when that new line is inserted instead of sticking to the specific cell.

I need to pull two pieces of information (date and maintenance performed) from each worksheet.

As I type this, I realize I may be going after the question wrong--instead of being glued to a particular cell, I need to attach to a 'most recent date' comparison? Either way, I'll need help. :-)

Thank you effusively for any clues or solutions! Please let me know if I need to provide more information.

Thank you for the response!!

I tried the indirect function and got the #REF!. Bummer. I attached a simple xls doc of what I'm working with (and my test).

Your help is much, much appreciated!

See attached.

Thank you both!
hoyasaxa215's sample on the .xls file got me there and then FDibbins' tip about spacing resolved the final hurdle (although it wouldn't work with any spaces, even if they matched--and that's just fine by me!)

Have to admit I have no idea how or why it works, but I guess all I need is the right formula.

Grateful for your insight!