Excel Template - Autopopulate data

I need to upload taxes to the state and I can do it via excel. I am a property management company who uses software that spits out all the numbers I need to fill into an excel sheet. I then transfer those numbers to a different excel sheet that the government provides. Essentially, I am trying to create a cheat sheet that eliminates the need to manually enter in the information. I want to be able to download excel sheets from my software, move the data to a master template sheet, and then everything auto populates.