Copy paste different data multiple sheets

Copper Contributor

Hi, I have different data from different sheets that I want to copy paste into another sheet. I know how to copy it with ctrl and mouse but to paste it I have to go to every sheet and Ctrl C then paste data in the sheet I need it. (ex. Sheet 1 data from B2 to B10, Sheet 2 data from C2 to B20, Sheet 3 data from F8 to F15 etc) Is it posible to copy all at once fron the different sheets and paste it in a single sheet or is it only possible using macros? Thanks for your help.

0 Replies