Import data using certain conditions

[NotarB]

I am new to creating macros on excel, and would like to know where to start.
I need to create a workbook to pull information out of another workbook, and put it in different tables based off of the text.

Are there macros available for stuff like this, or can someone point me in the right direction to start learning how to create something like this.

Any input is appreciated,

Thank you