How to Create a master sheet using a command button.

[ddlow]

Hello (new to VBA excel)
I have built a billing sheet for 6 physicians to enter their billing. I would like to create a master sheet using a command button, ie: The Physician would transfer their billing information from their sub-sheet to a master sheet using a command button. Is this a possiblity?

Thank-you for any help or advice avaliable.

[royUK]

The code in the Contacts form example here can be adapted for your use

[ddlow]

Thank-you very much!
I will give that a try,