I calculated figures from multiple spreadsheets into a summary spreadsheet. Now I need to make that summary spreadsheet accessible on Google Sheets, but I can't get the summary spreadsheet formulas to work in sheets. In Sheets, I get "Error - Unresolved Sheet Name." I followed the google drive instructions on how to convert it to google sheets, but sheets won't calculate properly.

First image is google sheets, second is the summary spreadsheet I'm trying to get working in sheets.

AutoSave ( Off) AR SUMMARY . Saved v Search File Home Insert Page Layout Formulas Data Review View Help ACROBAT X Cut Calibri v 11 A A ab Wrap Text Accounting Paste [ Copy BIU~ Merge & Center Conditional Format as Insert Delete Format Painter $ ~ % " Cell Formatting T Table ~ Styles v Clipboard Font Alignment Number Styles cells B7 X v fx =SUM('[2023 Q1 AR.xIsx]Crimson Q1'!$L:$L) A B C D E F G Q1 Q3 Q4 TOTAL DUE 2/3/2023 2023 AR SUMMARY Q2 MEMO BOYETT un 147,079.17 S 147,079.17 CLEAN 25,076.83 25,076.83 CRIMSON 14,007.34 S 14,007.34 9 FLYERS S 571.77 S 571.77 10 11 GLOVIS S 593.96 S 593.96 12 13 GREGS 1,026.17 S 1,026.17 14 15 JACO 15,708.96 15,708.96 16 17 JEFFRIES 5,348.26 S 5,348.26 18 19 KINGS 20 21 PAZIN U. 22 23 PEARSON 4,077.56 S 4,077.56 24 25 PINNACLE S 16,248.34 16,248.34AR SUMMARY .XLSX File Edit View Insert Format Data Tools Help 100% % .0 .00 123- Calibri 11 Y BISA B7:B8 fx =SUM(' [1 ]Crimson Q1' ! $L: $L) A B C D E F G H 2023 AR SUMMARY Q1 Q2 Q3 Q4 TOTAL DUE 2/3/2023 2 MEMO 3 BOYETT #REF! #REF! 4 5 CLEAN #REF! #REF! 6 7 CRIMSON #REF! #REF! 8 FLYERS #REF! #REF! 10 11 GLOVIS #REF! #REF! 12 13 GREGS #REF! #REF! 14 15 JACO #REF! #REF! 16 17 JEFFRIES #REF! #REF! 18 19 KINGS #REF! #REF! 20 21 PAZIN #REF! #REF! 22