I found here the code below which does exactly what I need and that is loop through sheets of a source workbook, copy a range of data and paste to another workbook where sheets have the same name of the source wb. Works perfectly until it comes to different named sheets where I get an error...