Cells automatically filled

Hi everyone!
I’m having a problem that I can’t solve or find any solution to... I’m so puzzled...
I have two excel workbooks (A and B), each with several worksheets. The workbook A has all the past gathered values. The workbook B has a new layout, to use from now on.
So, I’m copying the data from each of the worksheets of workbook A to the correspondent worksheets of workbook B. The problem (mystery?) is that as I copy the values to the cells of one of the worksheets of workbook B, the other worksheets in this book are being automatically filled with values from workbook A...
Is there any way of turning this automatic option off?
I appreciate all the help,
Thank you so much!

If you are pasting and you have multiple tabs selected, then the paste will apply to all the selected tabs. Select only a single tab before pasting.

Thanks for the feedback!