I have modified the pull function to pull a range of variables instead of one individual cell. They are returned as a string separated by various random identifiers, IE ":", "*", etc. I then use the returned strings and the Mid function inside the worksheet that calls the pull function to separate the returned string into the various parts I am looking for.

I am going to add a step in pull function that will add the current date into a cell in the referenced workbook. The pull function will also return that date as part of the string returned by the function. I can then add another mid function in the workbook that calls the pull function and extract the date that pull was run.

Now, since I am running pull functions roughly 150 times, the calculation time can be around 90 seconds. What I want to do is, add a conditional if statement for the pull function. If the date that the pull function was last run is greater than or equal to the last modified date of the referenced workbook file from pull, then do not update values, otherwise, run the pull function.

Ideas?