Is there a way to use data from one workbook for a new conditional formatting
formula in another?

I need to pull totals from several workbooks and combine in to a separate
workbook. I've tried but it keeps saying you can't refence other workbooks
in formulas. I thought maybe there would be a trick to it.