Reference Excel sheet with apostrophe in name

I have a large workbook with company names for each sheet. On some of the data sheets, I need to reference the other sheets. In doing so, I would start with an =sum( in the formula bar, then click on the cells in the pages I want. Easy so far, right?

Now, how about when I have a very long formula where I am just auto-filling, then changing the sheet name? How can I reference a sheet with an apostrophe (') in it's name?

According to this Microsoft Article, you can use a double-apostrophe ('') in the name.

For example, =sum('My Employee's income'!A1:A2) would become =sum('My Employee''s income'!A1:A2).