My brother has three separate customer lists by state and would like to keep
them that way but he would like to combine them in one file.  I moved all of
the lists to one file and placed each state in its own tab.  I now have a
combined tab and can copy and paste them into one without any problems.  
However, my brother doesn't know alot about Excel and when he gets a new
customer he wants it added to both the state tab and the combined tab.  I was
going to write a macro to copy and paste the data but I don't know the best
way to do this.  Any ideas?