Dear All,

I write a vba program to process a task and this program is sitting in
a workbook for each of the staff about 20 in the same department. Each
of them cannot see each other's workbook due to the nature of their
work but the process step is the same for all.
1) May I know how should I do to rollout the vba program to each of
their workbook? Do I need to do the import in the VBE?

2) they are using a workbook for each of the project. When they do the
subsequently project they need a new workbook to do the same process
again. If that is so may I know if I need to do the import all the
time when they use new workbook for new project? I cannot let them do
as they will access to the vba source.

3) there is a process where they need to transfer data from worksheets
to 1 particular worksheet to derive the subtotal. I created a toolbar
commandbutton to process. The problem is they need to go to the
specific or active sheet to process. If having 60 sheets then they
need to process 60 times. I do not want to put the button on sheets as
will create a lot of procedures.
Any other way to process by providing sheet number in inputbox and
process once for all the sheets(transfer data from all the source
sheets to a single destination sheet) What is the vba statement for
this?

Again, thanks for the assistance so far.