Hello!

If I have a spreadsheet where the data in each row corresponds to a
unique company, what is the fastest and easiest way to copy each row
reference to its own spreadsheet?

If the data in Sheet1 is updated, I want the data in the other sheets
to update too.

I'm starting with:

Sheet1:
Co#    Name    Address
1    ABC    DEF
2    GHI    JKL
3    MNO    PQR

And I want:

Sheet2:
Co#    Name    Address
1    ABC    DEF

Sheet3:
Co#    Name    Address
2    GHI    JKL

Sheet4:
Co#    Name    Address
3    MNO    PQR

Thank you,
Enelra