Reference specific cell from every spreadsheet on the workbook (except Spreadsheet X,Y and Z) and list results

[Marzagao]

Hi all!

I'm looking for a way to pull data from every spreadsheet in my workbook, except for spreadhsheet X, Y and Z and list the results on cell C11 in spreadsheet X.

I'm sure this is very straightforward but I'm quite new to VBA and am picking as I go, learning from each iteration. Can anyone help me out?

Additionally, can a macro automatically create a .txt with the results and update it every time the macro is run?

Thanks a lot for any tips!!