match words and extract out

Hi..
I need help

I have data in sheet1 and sheet2

What i want , whatever words which start at first match with sheet2 extract out into output sheet

For an example

if the Data in sheet1 column A is like "Tommy s/b","Tommy c/o","tommy,bhd"
but in sheet2 data in column A2 is "Tommy sdn Bhd"

Data in sheet2 Column A match with Data in sheet1 column A extract out all the data which start from words Tommy..
and delete all blank columns after extract out the data


I have attached sample in excel file

Thanks

what i meant is whatever words start from left in sheet1 column A2 must match with sheet2 column A2 and extract it out into sheet output..

I have 30,000 data's in sheet1 ..but i can't do it i manual way..

Thanks
Rj

Thanks
I make some mistake in there ..
I'm sorry..

I have attached another sample excel file..
Those strings in sheet1 column A2 match with sheet2 column A2 string and extract out into sheet output..

For an example if the string in sheet1 column A2 is "simon sb" , A3 " simon ltd", A4 " simon ltd incs" match with sheet 2 column A2 simon sb
so..those words which start from "Simon" all extract out the whole data and put into sheet 3..
Those which not same will remain i sheet 1..


Thanks
Rj