I think your design need some work.
There are several ways to get the data from Excel into Access:
1) you could import the SS into a table in access and use queries.code to put the data into the correct tables.
2) you could use automation to read the data from Excel and write it into Access. (lots of code)
3) you could write code in Excel and push it into the Access table.
I would probably choose option #2.
It would be nice to see your dB and the SS with a little bit of data - use names like Fred Flintstone, Barney Rubble, Jessica Rabbit
And would also need to know where the column data goes in the Access tables.
As far as the Access tables, I might start with
You don't need table "tblEmployeeCount" because the total can be calculated (and you don't have an "Employee" table)
I'm sure these are not the only fields/tables you would need, but without more info about your business, it is the best I can suggest.