Having one workbook reference data from 72 different workbooks (building the formula)

Job ID: 34039770

Budget: $30 – $250 USD

I have 72 workbook that each has 14 worksheets - 13 criteria sheets that summarize on the first '"snapshot" page. This part works. Now, I am creating a new workbook that has the snapshot data listed in a tabular format - so 72 rows of data. The reference to the source workbook is the same for each of the 30 fields - but for the name of the workbook. I can set up the first line. That works - although I have to click in each field and click to the source data. I then copy that first row's info into the second line and have tried to find and replace the first workbook name with the second. That part does not work. I have also built a formula that builds the reference ='[Workbook]Worksheet!'cell . This does not work either, I do not want to manually link each datapoint (72 sheets x30-ish datapoints). I do not know macros or VBA. Can someone please help?
Related categories: Visual Basic Data Processing Data Entry Excel Word