Combine single list of names

Job ID: 35968289

Budget: ₹12,500 – ₹37,500 INR

spreadsheet with 180 tabs with 18 names each with linked in URLs on the in some cases. I'm looking to combine them into one single list of 1800 names. Once combine, I'm looking to separate the column with names on it into first name last name.