Excel 2007 : Help with Automated Database

Hey,

I am a bit confused. I have made a mock-up of the database in the excel file. What I need is to enter data into the main database in the first sheet. Then it automatically enters the associate into the correct sheet (band) and the correct intersection within the sheet. I'm not yet good enough to know how to automate this using excel so I tried Access but I am still very new to it and this has not gone much better.

Any help is much appreciated.