First you create a month column and then do the union of all these 11 months data files to get the single data file which can be loaded in Tableau. This you can easily do in Tableau Prep.
Ok but the data is in the same excel sheet, not different ones. Do I still use tableau prep?
Yes, if it's complex to do it manually then you can use it.