Report automation and distribution via web with partitioned viewer access

Hi,

My name is Kneale, and I just joined the forum (sounds very Roman, doesn't it! )

My problem is I want to simplify my life by enabling a single workbook of multiple sheets to be distributed on the web, but for different persons to have access to 'their' sheet only.

I import raw data to a worksheet, manipulate it through pivot table(s) and then run macros to update report views to many pages in the spread sheet.

Currently I have to then copy and paste each work sheet to separate work books for distribution to recipients.

I want to allow access for people to view ONLY their relevant worksheets by sharing my workbook on the web.

Can anyone help me to tell me how I do this ??

Many thanks in anticipation,

Kneale Harris