I have searched the forum in hopes of finding an answer to my question. The answers I found need some embellishing please.

I have a workbook that I need to report on monthly as the data changes monthly. The basic "tool" doesn't change, but the monthly results do.

I need to be able to sum the values from different workbooks. For example, I want the sum of D13 from 10 different worksheets to appear on worksheet 12 in D13.

One answer said to start the function in the workbook needing the total, clicking from workbook to workbook selecting the cell needed and typing a comma before going to next workbook. What do I click after I select the last cell? How does it know I am done?

Another answer said to use Data>Consolodate. What do I select prior to Data? What do I select after Consolodate?

Another answer said to "add this for the workbook names you want"...'Drive\Directory\Folder\[workbookname.XLS]sheetname'!$n$43

I am completely lost.
Would someone please assist?

Thank you in advance!