Sending Data to a second sheet

Hey Everybody,
I’m looking for a little help on a project. Attached is a workbook that I’ve started. It has a zip extention but is not a zip. Rename it as Test.xls and it should work.
It will have three sheets, company name, RC#, and alphabetized.
What I would like to do is make an entry in sheet 1 (Company Name) such as:
A B C D E
A0010 Dewey,Cheatem,&Howe RC#269699 lawyers

My post didn't format correctly so heres a rundown
Column A A0010 an assigned number
B Dewey, Cheatem, & Howe company name
C empty
D RC# tracking number
E AKA also known as secondary title

And have it autopopulate and alphabetize (by column B) sheet 2 (Alphabetize). Then repeat for sheet 3 (RC#), but sort by RC# (column D).

I’ve got it set so when column B is filled in, it automatically numbers column A. The name is the only data I have to start with. A few days later I receive the RC# and other info. I need the RC# when filled in Sheet 1 (days later) to be attached to the proper company name on sheet 2.

As an example
Monday I get Dewey, Cheatem, & Howe and enter it in cell B 10. It automatically numbers A11 (in this case) and copies it to sheet 2 in the proper cell in the alphabetized list.
Wednesday I get the RC#269699 and enter it in sheet 1 cell D10. It should automatically enter in sheet 2 in the proper cell associated with the Dewey business. Sheet three should be updated automatically and sorted by RC# (column D). If your still with me your probably too smart for your own good .


It’s OK to keep the columns in order (ABCD) as long as the data stays intact, which is what I think DataSort does.

Is it possible, or have I been drinking to heavily at work?