Import Cell Data
 

Greetings!

In designing a spreadsheet to track creditor payments due, I maintain
creditor data in various worksheets. In my "creditor" worksheet, which
contains contact information and other information, I need to import the
current payment due from the relevant worksheet. In other words, the
'creditor' worksheet needs to pull this month's payment amount from
'worksheet 1' d12, but next month it will come from d13, etc.

What formula may I use to always pull the current payment into 'creditor'
from the last cell of 'worksheet' column d?