How do I bring specific data from one Excel spreadsheet to another?

We currently pull a report of data that needs to be broken into many client related files. Not each client needs all the data that is reported in this Excel spreadsheet. Is there some sort of method that we can automate this process to pull data, align in a new Excel spreadsheet with specific formatting guidelines? Not sure if we would need to create some sort of program or what. Any help will be greatly appreciated! Thanks!