Hi
I have inherited a invoice workbook which has a sheet for every invoice -
currently about 150 sheets.The invoice setup is identical change the data
differs. I would like to create a summary sheet which lists the invoice no,
date, vendor, nett, vat & gross. All the data is in the same fields on each
sheet but the sheet names differ. The field refs are Invoice no = I21, Date =
A21, Vendor = D11, Nett = I56, Vat = K56 and Gross = M56.
--
Tx
Jules