New to macros...

Hi, I am very new to macros with Excel, but I need to create a macro that will go out to a specified folder and pull information (pdf names, page counts, etc.) into an excel table. I am trying to learn as much as I can, but it all seems so over my head... :/ I seem to be stuck with what I need to do to incorporate other programs outside of excel into my macro when I am recording. I have figured out how to record a macro within excel though, so I guess there is something... :) Does anyone have any super simple guidance for a person who is incredibly tech challenged like myself?