Some sample source data and how/when it is generated would allow for more focused help. In other words, how dynamic/fluid is the data? Is it a worksheet that is replaced periodically? If so, does it get a new name? Or the same questions but for a workbook. The answers may reveal that you could start by linking the spreadsheet to Access as if it were a table, then use a couple of queries to populate the required Access table(s) every period. There are also other methods such as TransferSpreadsheet, or automation (more complicated) or using an import specification. All depends on what you have. That is all related to stage 1. If there is a stage 2 it will likely be massaging the data so that you can do what you need reliably and without a lot of unnecessary work. What you're doing now is not only a lot of unnecessary work, it's untenable.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.