Excel Automation

I need automation in Excel from my travel portal xls file. need to extract client name, booking id flight number, pnr, amount. in case of any cancellation or any ammendment