How do I combine multiple excel .csv files into one spreadsheet with tabs?

I have 14 separate excel .csv files and am in need of converting them all into one master file with each file having its own tab. I know how to convert the 14 separate .csv files into one file with one tab, but not multiple tabs. I want each .csv file represented on 1 spreadsheet as their own tab, and populate... show more I have 14 separate excel .csv files and am in need of converting them all into one master file with each file having its own tab. I know how to convert the 14 separate .csv files into one file with one tab, but not multiple tabs. I want each .csv file represented on 1 spreadsheet as their own tab, and populate certain information from each tab. The .csv files are number driven, the easiest example I can give is for football:

.csv file 1 shows each team and their assigned number (Team ABC = 1)
.csv file 2 shows Team Number and Team Rushing Yards (1, 600yrds)
.csv file 8 shows Team Number, Player, and Player Number (1, Bob, 320)
.csv file 9 shows Player Number, Team Number, Rushing Yards (320, 1, 600yrds)

As you can see in this example, each file has information that can carry over to the next file, but irrelevant in another. Hope this makes sense, my brian is fried trying to get this to work.
1 answer 1