In trying to give you an answer the biggest problem is a lack o
definition.

Your proposal of having a proforma workbook preformatted with graphs i
a good one - something I use regularly. Although I am not sure why yo
would need one for each supplier. Logic suggests one generic ne for al
suppliers and then customize it on the fly.

so ...

for each supplier
copy proforma workbook to supplier_name.xls
open suppliername.xls

update supplier data

update tables etc
next

The tables should be easy enough but might (depending on how you do it
need the data ranges on the graphs changing.

I don't understand why "the last sheet would need replacing in it
entirity" this seems like a bad idea resulting from a lack o
imagination. But it might be the right thing to do.

regard

--
tony
-----------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=56199