No, Tableau can't automatically detect the files from a folder. You always have to select the files you want to add in your workbook. You can join different excel files on some common key in table editor & here is one useful link: - Joining Excel Worksheets | Tableau Software
You can also use data blending to join the different excel files.
Hope this may help!