What you are doing looks correct. On a point of terminology - the tables with identical fields are auto-concatenating rather than joining. The other tables will associate with those records regardless of which of the 10 sources they came from. As Andrey said, its hard to disgnose without some sample data.
Is it possible that the 10 files may overlap a little, so some items are being double counted?