Hey,

in my Workbook I have "Master" sheet. I would like to have a macro that copies specific range (eg: A5:J5) in an Active Sheet (same workbook) and pastes its VALUE to "Master" sheet (each time in next row), eg starting in row 3. Each time I will have a new sheet there will be macro applied on for "adding value to Master sheet".

Thank you for help.