I have data stored on a sheet that I want to access from another sheet.
The data is stored in rows with a varying number of data items on each
row. Is there a worksheet formula to return the value in the last
occupied cell on the row?

Any help would be appreciated.