i have a google sheets where i keep track of all my items that we import each line has the model number, cost, container number, ship date, landing date etc..
since there are so many its hard to see exactly which models are coming when. i would like to have sheets (named by the model number) for each model number so that when we add a line onto the main sheet it should copy straight into the correct sheet. that way i can see each model separately.
what would be the best way to do this?