Yes.
1) If the data on the four sheets has the same structure, and the column
headings on each sheet are exactly the same as the field names you want
in Access, it's usually possible to import all the sheets in succession
to a single table.
Often it's less troublesome if you create the table manually with the
exact field types and field names you want (remembering that these must
match the data and column headings on the worksheets).
2) If the structure of the data (or the column headings) is different
between worksheets, usually the best thing to do is to temporarily link
or import each worksheet, and use an Append query to move its data to
our main table. By using calculated fields in the query you can import
an Excel column to a field with a different name, change data types, and
so on.
