For what it's worth, here is a rough attempt at what you originally were looking for where the spreadsheet is updated after the Save button is clicked.
I've based this on the following:
- The Input form in access has: Staff ID (ie a unique number), First Name, Last Name, Leave Type, Leave Date...