Hello,
I'll create a script in the workbook, this script goes under the events section of the workbook. It will read the values of your last row on another spreadsheet. It's really quick to do. Please provide workbook and I shall assist.
Sincerely,
Justin