Both of your actions require you to open an Excel Application object. So the FIRST step is to read over application objects, which you can do from the Help files.
Look up the following help topics while you are at it.
In access, read up on "collections." Their discussion is better than Excel's discussions on same.
In Excel's help files, look up the VBA interface to see the objects exposed to VBA.
To do the things you need, you must create the Excel Apps object, then open the workbook (file) for that object. When you do, you expose a collection called "Worksheets" - and Worksheets
.Name is the name of the Nth worksheet of that collection. To capture that to a table, you need to do a recordset operation, I suppose. So look up recordsets if you have not used them before.
In a sheet, you have various objects including ranges, rows and columns, and cells. Cell is ambiguous. When enumerating a row, each column is a cell. But when enumerating a column, each ROW is a cell. If you want the long reference to a cell on a worksheet it is
appsobject.worksheet(i).rows(j).cells(k)
for the Ith worksheet, Jth row, Kth column. But the contents of a cell gets messier than that. Look in the help for the fine structure. I think there is a .Text property for the cell that holds what you want, but it might be a property of a subset of the cell. The Excel help files should tell you what you need to know.
One final word of advice. PARTICULARLY for apps objects, ALWAYS remember to close what you open. Otherwise you run out of memory so fast it'll make your head spin like Linda Blair in the Exorcist.
