Did you Try UNION your Eight Data sources and then Joining with Shapefile?
Try Using Tableau PREP
Thanks Deepak. I'm trying a UNION right now. Seems like I have too many similar column names in my Excel sheets for that, however. So I'll have to rename them first. Tableau PREP looks great, but for now I should be able to organize the data myself since it's not that much.
It will be good, if you have same column names across all your datasets. You can easily Union them those 8 Datasets. It works like this data would be arranged columnwise on Top of One Another and You Get 2 Additional fields called Sheet and Table Name which you can use to Manipulate data.