Transfer data

I have an excel spread sheet that has columns for last name, first name, office locations, and date. I may have 10 items listed in the column location for Boston and 15 for Los Angeles. Is there a way that when I type in all the information in Sheet 1, then any location that has Boston as a location is automatically entered also in Sheet 2 and the data for Los Angeles is automatically entered in Sheet 3?. I am using Excel 2010.