|re: "I have linked column C1 of all the 100 plus tabs..."|
C1 is a cell, not a column, so I assume you mean that in Column D of your master sheet, you have formulas such as:
Read this thread and see if it helps. There are actually 2 different suggestions in that thread, so make sure you read through it all to see if one or the other fits your needs.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.