I have a site (home/vessel_schedules) which includes multiple sub-sites e.g. home/vessel_scedules/vessel_1. Each sub-site has a document library which stores all schedules for that vessel, for archiving and for sharing among the users. These schedules (documents) are saved automatically in the respective library using vba on a special Outlook account (there is a specific account used, which all the schedules are sent to from a vessel, the VBA code there distinguishes where they came from and saves them in the respective SP document library).
I have been requested that on the parent site (home/vessel_schedules), a general overview of vessels schedules is included, thus displaying the last schedule added for each vessel. I am searching an OOT solution (possibly) that will allow when a schedule is added in a document library, on a subsite, to copy the same document in the list on the parent site (and replace the last one of the same vessel). Since there are approximately 20 vessels and the documents are never edited by the users, duplicating the document will not be a problem.
I understand this is not possible with a SPD workflow, and I would be grateful for any "painless" solution or pointing me to the right direction. Thanks in advance!
PS. Keep in mind the documents carry properties which are displayed as SP columns (e.g. last port visited, etc)