You do not have a clear understanding of your work procedures.
You do not understand what even that basic software Excel can do.
You mistakenly believe that implementing RPA package software will solve everything
when you can't define your own business procedures.
You mistakenly believe that VBA will organize and solve
all your numerous inconsistent Excel files.
You do not know the nature and characteristics of databases,
but you have a vain hope that Access will solve something for you.
If you humbly admit your ignorance and seek the teachings of experts,
you will be on your way to solving the problem.
Then
we will be there to help you.