Data entry from two PDF files to an Excel workbook

This project is to enter information contained in two PDF files into one spreadsheet, "Card cycles and yearly spreads".\r\n\r\nThe first PDF "1. Card Cycles" needs to be entered into the first five sheets of the workbook, these sheets are:\r\n\r\n1.1 Cards by planet position\r\n1.2 Cards by planet line\r\n1.3 Cards by result\r\n1.4 Cards by challenge\r\n1.5 Cards by year\r\n\r\nThe PDF file "1E. Example data - card cycles" contains how the relevant information corresponds to the sheets. The first card from the example has been entered for these sheets.\r\n\r\nThe second PDF "2. Yearly spreads", has a number of years that need to be entered into the sheet "2. Yearly spreads". The PDF file "2E. Example data - yearly spreads" contains an example of the first year which has been entered into the sheet.\r\n\r\nI have turned on data validation to assist with accuracy.