Gather data from attached PDF's and enter into a spreadsheet.
I want a listing of all cabins numbers and associated information from PDF's for 11 ships.
Information retrieved will be from deck plans and include cabin number, deck, category and any notes about cabin.
This information will go into a spreadsheet with different workbook for each.
This will be a manual job unless you can figure a way to get the data from the PDF's.
I have attached a sample spreadsheet. Each ship has about 5-6 decks of cabins.