title: command bar "workbook tabs" how to do to pick automatically
body: <p>With my macro im using about 300 files. I want to do the summary of all these files in one file. I have the array formula to sum some staff. I just write a formula without opening each of the file. Anyway, let's assume that the formula is:</p>
  <blockquote>
  <p>='sciezka &amp; [nazwa pliku.xlsx]Interest table'!$E$1</p>
  </blockquote>
  <p>The problem is that about 280 files have this sheet called &quot;interest table&quot; and everything is fine.
  However for the rest of the files I have to each time select the sheet because there is a dialog box / command bar &quot;select sheet&quot;.
  <a href="https://i.stack.imgur.com/pXw76.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pXw76.png" alt="enter image description here" /></a></p>
  <p>Is there a way, with some vba formula, to force excel to choose the first sheet available or not to choose any and in the cell I will get the error?</p>
  <p><a href="https://i.stack.imgur.com/a1Dg5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/a1Dg5.png" alt="enter image description here" /></a></p>
  <p>I tried
  <code>application.displayalerts = false</code> but it is not working
  It would be great for me if the window wont show at all.</p>
  <p>Thanks in advance for any comment</p>