So I am a beginner to VBA and have been trying to attempt what I thought might be easy but maybe its not? I am trying to create a macro that asks what workbook to pull from (From there I can select any) and then pull from specific cells each time to lay them out in a chart.

For Example: Workbook A pulls Cell B5 from Workbook B and posts it in Cell A2 in WorkbookA, then pulls cell C15 from Workbook B and posts it in Cell B2, etc. Finally once it creates a row stating all the information from Workbook B I want to be able to select another Workbook (Workbook C) and do the same but have it populate one row lower. (Aka Workbook A would pull from Workbook C and post information in row 3.

Is this doable? I've been trying to go through some wise owl tutorials to help me out but if anyone has anything that would streamline this learning process it would be greatly beneficial. Any advice or tips is helpful.