Hello Tracy,
If the Balanace Sheet and cashflow are in the same workbook, then you can use the "QUERYSHEET()" formula to pick up the numbers from the other worksheet. By why don't you want to pick up the numbers again from the general ledger? That might well be simpler.
_________________________
Andrew Bates