title: How to use indirect formula to show value AND formatting?
body: <p>I have attached the example file just in case my explanation is not clear.
  <a href="https://ufile.io/l4env" rel="nofollow noreferrer">Excel Case 01.xlsx</a></p>
  
  <p>So everyday I need to e-mail to my customers their daily delivery order based on their request and contract. Usually, they only order what they requested and leave out their required take of daily order.
  So, I usually mark the "forced" order using orange color.</p>
  
  <p>Each file is based on each month. And each sheet is based on each day so I have July file with 01,02,03 etc as sheet name. Each sheet has company and products details and the amount kgs of their order.</p>
  
  <p>Each day I have to email them the "forced" order only to notify them what's coming to them.</p>
  
  <p>Now, I have separate sheet for e-mail like this:
  <a href="https://i.stack.imgur.com/5cKX6.jpg" rel="nofollow noreferrer">Excel Case 01 - E-mail.jpeg</a></p>
  
  <p>My formula for cell D6:D10 is:</p>
  
  <pre><code>{=IFERROR(INDEX(INDIRECT("'"&amp;$K$4&amp;"'!$A$2:$H$6"),(MATCH(1,(INDIRECT("'"&amp;$K$4&amp;"'!$A$2:$A$6")=$B6)*(INDIRECT("'"&amp;$K$4&amp;"'!$B$2:$B$6")=$C6),0)),$K$7),0)}
  </code></pre>
  
  <p>The problem is that the orange color is not shown in that column and I need the color so I can use the filter by color option. I also want to keep the "Sheet Name" function so that I only have to change the sheet name to get the datas that I want since I will have up to 31 sheets.</p>
  
  <p>Is there a way to keep the indirect formula to show not only values but also the format of the referred cell?</p>
  
  <p>Thought of using paste link VBA but when I searched for the codes, it seems that I only find codes that refer to specific cells.
  But I don't mind using VBA if I can still use the "Sheet Name" function.</p>
  
  <p>Thank you in advance.</p>