Macro copy paste data from multiple worksheets into one

[l_lolo]

Hi,

I have been searching for a macro that will copy and paste data that I have in multiple worksheets to my "tremplate worksheet". I have seen a lot of posts but none of the macros totally works for me (I am new in this).

If someone could please help me I'd be very gratefull.

I attach an example pic (and add steps that I need and "restrictions"):

Restrictions:​

- The worksheets I use come directly form SAP. As you can see in the examples the collumn names that I have written in my template are not necesarilly same as the ones from the downloaded worksheets.​

- In one of the sheets (source 1), I have a collumns that I need to separate by the delimitator (-). For that I need to first add automatically a new collumn and then separe the other into 2.​

- As some orders may be cancelled and reopened (the data that I would have already in my template sheet may thus change), I need for the data to update automatically. Same if new rows are added to one of the sources, I need for them to be added automatically to the template sheet.​

​

Objetive:​

- add 1 collumn on the right in one of the source worksheets​

- Copy and paste cells from various sources in one worksheet​

- Update the already copied data f anything in the surces changes (for example, from I receive material from and order than has been placed and appears already in my "template").​

​

Any ideas?? Thanks a lot in advance,​

 

[l_lolo]

Another restriction: although the data of one source and another have a connection (in one sheet you have a prod, in another prod&order, and on the 3rd order&price) they are not int he same order. Hence I belive thatin the macro it also needs to appear some function that will look for the order and copy the price of the order (some kid of vlookup).