Hi algram. I have removed your e-mail address for your own protection; our site rules do not allow the open publication of e-mail addresses as it can lead to all sorts of messages arriving in your in-tray - and the deluge of spam is bad enough as is.
It is possible to import Excel worksheets directly into Access, or better still to use the File, Get External Data and Link Tables options to link the worksheets to Access instead of importing them. Linked tables can be queried and updated just as other Access tables can, with the advantage if you go this route that you retain the Excel workbook structure intact.
However, with a 24-page workbook you may well find that the data has anomalies that make it difficult to transfer to Access without resolving these first. This assumes that the 24 worksheets are tabular in structure, and that their content and design mirrors a relational database approach of developing a set of normalised tables.
Excel is not a relational database, so it has no tools for enforcing relationships between tables (or even encouraging their use). It would be somewhat surprising if the Excel data concerned was truly related (in the relational database sense) or normalised.
Once you have the data in Access you then have to build a set of queries linking the tables together, a set of forms to provide a user interface, and a set of reports to provide published results.
If your boss thinks that this should be done because it will be easier for users I would doubt that he or she has a realistic view of the scale of the undertaking, and its complexities, but it can indeed be done if care is taken to ensure that the tables concerned are imported and converted if need be into true relational tables. Trying to use a relational database on non-relational data - where there are repeating groups or merged entities for instance - is at best inefficient and at worst impossible.
-Stewart