How do I combine multiple excel .csv files into one spreadsheet with tabs?
.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.