Transfering from 2 work books from multiple sheets and updates itself

Karol-

Try looking at this post.  It references another way to go about what you're doing that may work better depending on your particular scenario:

https://techcommunity.microsoft.com/t5/Excel/Adding-information-to-different-sheets/td-p/194438

The workbook should update using your current method too though.  Have you tried going to:

1. Data Tab

2. Connections

3. Then Selecting the link and refreshing it

or

1. Data Tab

2. Refresh All

I'm attaching the workbook with data connections to this post as well for easy reference.  It uses links to the source data in order to get different "views" without modifying the source data.