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;