Import ebay multi accounts sale in one spreadsheet

Hello I'm Looking for someone who can help me to create the VBA Excel file to import all orders from the multi eBay accounts in one spread sheet. 1- Import Multi accounts sales to one spread sheet. 2- Column like AW(maybe) has texted value "dispatched" or "waiting". 3- Column AW has text value dispatched then automatically mark as dispatched on eBay end of day. 4- Once Dispatched orders are marked as dispatched then they get move from current order sheet to another sheet and keep them save.