Macro to copy data on all sheet

[howard]

I need code that will copy the data on all sheets on workbook BR PE Parts and paste this on the respective sheets on workbook BR statements

Your assistance in this regard will be most appreciated

 

[JackDanIce]

It would help if you were more precise in your request - is this a simple copy and paste? What do you mean by respective sheets in wth workbook BR statements? Without knowing what your two workbooks look like, there is no way for me to guess what you mean by respective or make any other assumptions

 

[howard]

Thanks for the reply

The workbook BR PE Parts has 4 sheets. I need all 4 sheets to be copied and pasted in the workbook "BR statements" on sheet 1 to 4

It is a simple copy & paste