Err: 508 When trying to Auto Replicate/Transfer data between two sheets.

[Vince]

I am using AOO Calc vers 4.1.2 and Win 8.1x64 (file name is 2016 My 
Bowling Score Data.ods).

I want to "automatically transfer" the data that is typed/entered into 
Cell M342 of the Sheet named: 2016 Scores into Cell D6 of the Sheet 
named: 2016 Match Play.

The Cell M342 data is calculated by the formula:
 =SUM(C342:K342),
which yields a result of 386.

I have entered:
=($'2016 Scores',M342)
into Cell D6 of the Sheet named: 2016 Match Play.

Cell D6 results in Err: 508.

Is this error due to an improper typography?  Any suggestions are welcomed.

VinceB.