I have a spreadsheet that has rows added to it by different areas of the
office. I need to set up a "front sheet" that will always show the last
(bottom) row of "sheet1".

I think there is a expression that will do this for me, but I do not know
what it is or how to construct it. (I think it comes down the rows until it
hits a blank then goes back up one row)

Can anybody help with this please

Bob