Can someone please help, I want to make a summary sheet that reads the contents of the last cell used in a column on another sheet. The cell i want to read keeps moving down a column as data is inputed in the workbook.
I know how to read the cell number but i need to read the contents.

This has been driving me crazy, Thank you