1 of 1 people found this helpful
Yes! You've to union your sources before that you need to consolidate all your excel files in a single workbook. Once done then connect the consolidated file and drag all other sheets on top of first sheet to union. If you don't want to consolidate then follow the other approach
Convert your excel files to .csv and put all 12 text files in a folder then connect any one csv file, tableau will automatically list down all the csv from your directory in Sheets sections. As you've mentioned data structure is identical then just drag other sources on top of connected source to union all the files. You may find several links and online help over net about union.
Let us know if this help.