Hello. I am interested in using a cell formula to pull the most recently entered information from one sheet to another. The destination sheet would almost act as a report and would only display two pieces of information - the "Team Health" and "Internal Update".
The reason I would like to do this is to ultimately "link cell data" for most recent Team Health and Most Recent Internal Update to another sheet in my project folder. The way we have it set up now would require us to always update the linked cell each time we add a new update.
Please let me know if I can clarify what I am asking in any way. Thank you!
