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.