Excel VBA Using a function in a cell to pull in data from different sheets
I have several workbooks with data in a similar format.
I know that you can call a VBA function in a cell.
Does anyone have an example where this technique is used to pull
data from several sheets into one?