best way to turn many sheets/tables into usable data??

[Gingertrees]

I have numerous reports from 3 companies, showing reports for sales by year and salesperson for 2 of our items. I've grouped them into a large Excel workbook, but I feel like I can manipulate them better if I transition this to Access.

They're organized like this:
(sheet 1)
Company 1 - ItemA
State / 2008 / 2009 / 2010 / Salesperson
===============================
AK / 1,000 / 8,000 / 3,000 / Jon
AL / 430 / 2,000 / 1,400 / Sara
AR / 2,000 / 6,000 / 8,800 / Jon

(sheet 2)
Company 1 - ItemB
State / 2008 / 2009 / 2010 / Salesperson
===============================
AK / 500 / 800 / 1,000 / Jon
AL / 4000 / 20,000 / 11,400 / Sara

(sheet 3)
Company 2 - ItemA
(etc)

For whatever reason, I'm drawing a blank on how to best organize this for Access. I tried importing each sheet as a table - oh boy, that didn't work very well. Ideas????

 

[CharlesChuckieCharles]

go for granularilty

create a table of
Company,item,state,year,value,salesperp

thats pretty simple and gives great flexibilty

if you go for Third Normal format its a lot more work

 

[Gingertrees]

Thanks - I think I got hung up on the Normals, to my detriment.