Advanced Excel Mods Needed

1. On the Buyer Report Sheet the final column Preco Total, and Pedido Recebido is not changing when a different week is selected. As you select a different week, all the data on that page should be unique to that week…i.e. items purchased, Preco Total, Pedido Recebido. 2. Just double check that NO rounding is occuring between the user data and the master calcucalations tab - to me It appears that when I collect the data from each user it is being recorded properly under the clients tab, but when summed up using the INDEX function for any of the report pages the process either rounds up or doesn’t show any value number below 1. Do we need to use a different function other then INDEX or is there something missing in the cell features. 3. I need the final email output to be formatted better…it doesn’t have to be a CSV file…can be an htm or pdf..but would like it to be formatted better where you can actually see the cells, and doesn’t include all the extra line information at the end of the printout. I have attached an old coy of the file...when ready to work on the LIVE file I can give you a live file to work with. Until then, I need to keep the original with me. A VERY quick turn around is needed on this project. Thanks in advance!