Formula reference with apostrophes questions

Hello! I have a consolidation table with multiple sheets. When making a formula to use values from certain sheets the formula appears with apostrophes' (e.g. ='PL_EUR'!S150), while for some sheets wi...