Copying details based on cell info

[Finalfrontier1976]

Hi,

I have a spreadsheet (attached) and on it I have a tab called "Complete". What I would like to do it as I add or alter the details of the depots on the Complete sheet it is copied to the tab which has the same name as the depot column. So, for example, lines 2-13, I would want the details (Registration & Tyep) copied to the tab called Birtley & Tibshelf. If I then altered the depot location on the Complete tab the would disappear from the Birtleyt & Tibshelf sheet and appear on another sheet in my worksheet with the new location.

Thanks,
Lewis

[BadlySpelledBuoy]

In the attached is one method of accomplishing this that uses a helper column (C on the "Complete" sheet) to generate a unique number that can be used to look up the values into the other sheets.

BSB