Multiple sheets import vba

I this is my first post in this forum sorry if it's something easy, but I'm a newbie in VBA and I need to do this for my company but I can't really figure out how.

I'm having problems integrating/merging the codes posted with my actual code, the other codes besides mine are able to import data from multiple sheets but I can't figure out how to implement them in my own code.

My actual code and made by me and a lot of help from tutorials is this:

Please Login or Register  to view this content.

This is one of the codes that can import multiple data from more than 1 sheet, and I would like to merge this code with mine or if someone ably the principle to my own code. (1ºCODE):

Please Login or Register  to view this content.

This is one of the codes that can import multiple data from more than 1 sheet, and I would like to merge this code with mine or if someone ably the principle to my own code. (2ºCODE):

Please Login or Register  to view this content.

I thank you for any reply in advance.