Newbie Having His First Go At SQL In Access

Ok, I've been given a task to create a hierarchy diagram for my company, unfortunately the diagram has to be created using one excel spreadsheet. I would prefer it if the database could be created using the smallest amount of user input, so all he user has to do is import the spreadsheet to access and hit a button then the hierarchy is created.

I'm currently only going one step at a time, trying to sort the data from the spreadsheet using queries. But this is the problem:

Raw Data table
ID, Firstname, Lastname, Status, SupervisorFirstName, SupervisorLastName

Table1
ID1, Firstname1, Lastname1, Status1, SupervisorFirstName1, SupervisorLastName1

The idea is that the hierarchy diagram should start with the boss and move down to the mere siblings like me, and everyone will be connected. But for one reason or another this isn't the case, so at the moment I am trying to move the persons record if their supervisors name is not in the tree, so the SupervisorFirstName and SupervisorLastName are not in the Firstname and Lastname column.

I have been using the following SQL

INSERT INTO Table1 ( ID, LASTNAME1, FIRSTNAME1, Status1, SUPERVISORLASTNAME1, SUPERVISORFIRSTNAME1 )
SELECT ID, LASTNAME, FIRSTNAME, Status, SUPERVISORLASTNAME, SUPERVISORFIRSTNAME
FROM RawData
WHERE (((RawData.SUPERVISOR_FIRST_NAME)=FIRST_NAME) AND (RawData.SUPERVISOR_LAST_NAME)=LAST_NAME);

When I change the LastName to "SMITH" I know how many records I should get and it works, but how can I go through both columns finding any matches??

I may have described this quite badly so if you need any more info please let me know.