VBA to Import Data from a Series of Workbooks to a Single Sheet or Access Table?

[Endlessknight]

Greetings all,

I have a folder with a series excel workbooks. Each contains only a single sheet. I need to extract only 2 cells from each sheet. The first cell is fixed,. The other cell is always the last cell i.e. the last cell in the rightmost column.

Is something like this possible with VBA?

I know how to import a folder of Excel files to a single MS Access table but I don't know how to be select with the data pulled.

Thanks in advance for help/input offered.