VBA Macro pull a certain cell in closed workbook and copy/paste into current workbook

Hello,

Can anyone please assist me in how I would go into 4 workbooks and pull a certain cell and copy and paste that data into the current open workbook w/ the macro. I am new to VBA and trying to start out basic. An example of what I am trying to accomplish is below.

I need to go into workbook1, workbook2, workbook3, workbook4, and pull a cell off each sheet named the Trial Balance, however, the length of the trial balance will vary so the number of rows varies. The total is always in column C, but the number of rows vary. A unique identifier is the cell directly to the left (column B) always has the word "Total:" beside the column C total that I needed copied and pasted. I would then like to copy and paste the Trial Balance total in column C from each workbook in cells A1, A2, A3, A4 of the current workbook with the macro. Can someone please provide any guidance on this? Any help is greatly appreciated!

Thanks!

Duplicate thread

https://www.excelforum.com/excel-pro...k-w-macro.html

This is the same end result data wise but a different question on how to do it differently

Same to me, just divide the total by 2 should give you the result that you want.