Automated data scrape from 466 urls scraped

I need about 466 urls scraped. They're all Wikipedia pages, so it should be reasonably straightforward. I'm looking to create a dataset of every player transfer in the UK Premier league. Each team has a page for every season they've played in the league. I've attached a spreadsheet with all the urls for each team. E.G. [login to view URL] [login to view URL] [login to view URL] The information I need is under the 'transfers' part. I'd be grateful if you could scrape the information from every URL. I need the full tables for players in, players out, players released and players on loan. The full information is required (Date, Position, Nationality, From/To and Fee). The nationality is generally represented by a flag. Is it possible to pull the actual name of the country instead? Hopefully that all makes sense. It might be best to present the data in a chronological order, seperated by club. Attached sample file format to scrape I'd be grateful if every team could have its own table of transfers generated, and then a final sheet with all of the transfers in one table.