I have a worksheet that contains several worksheets. I would like to
get the information on tab Sheet 1 and copy cells (A2:O2) in a tab
name Sheet 2.

Can someone share the code to do that ? Or inform me where can I go to
read about it in order to accomplish this.

Your collaboration will be appreciated.

Luis