The first thing I would probably do is to combine all the worksheets within the Excel file. From there, some specific formatting will need to be done. Jonathan Drummey's post will probably be helpful for this:
Yeah, this is a monthly issue so I was trying not to manually massage the data as that is a lot of manual intervention. I think I will write C# code to redo the excel file and make it useable for Tableau. Then they can run the C# code each month and then use Tableau. It is a shame everytime we seem to have to massage the input data for Tableau, wish it could use the database tables better. Most of this data is already in a db table but not the format Tableau needs to get the output wanted. Oh well! not the answer I wanted but thanks.