Wondering what the best way is to move data from one sheet to several other
sheets, based on the value that is in the first column.
Working with several rows/columns of data. Each row contains several pieces
of data, with the first column being the important piece in determining where
the data goes. Sample below:
A B C D E
1 Ford Fusion Red 4 Door Manual
2 Toyota Camry Black 4 Door Auto
2 Ford Mustang Grey Conv Auto
4 Honda Accord Blue 4 Door Auto
5 Chrysler Sebring Red Conv Manual
6 Honda Civic White 2 Door Auto
7 Toyota Avalon Red 4 Door Auto

I have individual tabs for each car, so one for Chrysler, Ford, Toyota,
Honda. Need to find a way to move the data from the consolidated sheet to the
individual sheets. With all of Chrysler's data onthe Chrysler tab, Ford on
the Ford tab, etc...
Thanks for any assistance, novice at this.