Referencing all worksheets

[anthonator]

Hi all. I’m going have multiple sheets with the same formatting. In A1 is going to be named. Some sheets will have the same name and some will have different names. Let’s say B2 will have a value on every sheet. What I want to do is add the values of B2 in every sheet with the name Tom. I have already made a dynamic sheet list defined name of ‘Sheetlist’. So can I use an IF function and SUM function across all sheets with a formula. Yes need it to update automatically. I know I need to use INDIRECT, but I’m not sure in what way. Thanks in advance!!

[KOKOSEK]

Hi,
Can you attached any sample file, please?