Clarification; I want to combine all 12 excel worksheets into one excel worksheet without having to  copy & paste each onto the final excel worksheet.
Is there a better way to do that?

You likely need VBA to do this.  A simple import from Excel to Access can be done with a simple VBA command (one line of code).  But this isn't a simple import.  You want to import all worksheets, and then APPEND them all together to form one big list.  So you need to learn "append queries" as well.  And you need to learn how to run append queries with VBA since you don't want to do it manually.

So maybe I'm not understanding completely. Setting the combining of the sheets aside as another topic, why not just import the sheets on a monthly basis as you get them?  I don't understand combining the sheets for a whole year then doing the import.

Another topic for consideration would be cleaning the data once you import it.  Just based on some of the sheets I've seen, the data is not presented in a relational manner.
You would have multiple listings of owners, multiple instances of a particular dog, multiple awards for that dog.

There is a ton of examples for Importing from Excel, Exporting to Excel, and scrubbing your data just in the TechHelp.  Even more in the regular courses.

Personally I would let Access do the heavy lifting then, if you need to, output the data to Excel.  Let me know it you would like links to the videos.  There are many.

Well, honestly it is because when the national club secretary sends me the monthly report in an email, I simply download the excel file into a file folder on my desktop. I only run reports annually for the club so at the beginning of each year I put all of the 12 workbooks or worksheets sent to me from the secretary into one worksheet that conforms to the main table in my access database.  I import into a new table and do a few things with the new table then i append to the main table in the db.  then I run the annual year end reports.  I really do not want to mess around with the information every month when I can do it in a couple of days once a year.  I thought there must be an easier way to combein multiple worksheets from workbooks into one worksheet...a kind of drag and drop.  but seems there is not.  Thank You