Simple webscraping project from single website

Job ID: 35424477

Budget: £10 – £20 GBP

I want to extract drug data from https://bnf.nice.org.uk/drugs/ ( needs to be accessed via vpn as only accessible from UK) for each drug and the same from https://bnfc.nice.org.uk/ to create drug database for children.Here the column labels and numbers may be same or different- not sure
Need a UI path or Python bot to extract data from each drug and populate the appropriate column. Not all drugs have information in each column . If no information ,column MUST be BLANK.