Worksheet - Quote log

[musab]

I need help please. THis is my problem:

I have different quote logs in different workbooks. They all have the same
format. My problem is that I have a Master Quote Log and when I have to
enter the information in the Master Log and then in the individual log. What
I want to do is to put all the workbook into one and have different sheets.
So that when I type in the Mast quote log the info. automatically goes into
the individual log. Please advise on how to do this.

Thanks

[PY & Associates]

Enter data in Master workbook;

trigger a macro:
copy relevant data into formatted area of this worksheet;
add a new worksheet;
ask for worksheet name;
copy the formatted area into this new worksheet;

"musab" <musab@discussions.microsoft.com> wrote in message
news:74B98175-A475-4344-ADD1-E7EF676DF44E@microsoft.com...
> I need help please. THis is my problem:
>
> I have different quote logs in different workbooks. They all have the
same
> format. My problem is that I have a Master Quote Log and when I have to
> enter the information in the Master Log and then in the individual log.
What
> I want to do is to put all the workbook into one and have different
sheets.
> So that when I type in the Mast quote log the info. automatically goes
into
> the individual log. Please advise on how to do this.
>
> Thanks