Your data files look like monthly updates that need to be appended together - see this link and look at wildcard union - Union Your Data - Tableau
it will tell you how to put your separate excel files into a single folder and bring them in all at once - next month you add Nov to the folder and being the folder in - they will all be appended together
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks Jim for the quick reply it helped.