Can Functions call Macros?

I'm sure this must have been asked before, but I cannot find such a thread.

I have a workbook with several worksheets. I want to consolidate data from each of 22 worksheets into one display worksheet. Not all of the 22 worksheets will always have data, so I want to automatically hide the columns in the display worksheet representing the worksheets with no current data.

I know Excel will not run a macro from a Function; that would be too easy. The result I want, if it would work, would be to use the IF function to say:

IF(cellX>0,show_column,hide_column).

There must be some way to accomplish this relativly simple task.