Ok not sure if this will work but if you add Sheet 2! before all of the "A1" to Read "Sheet2!$A1" and add the dollar sign before the B in the meta data. You can copy and paste it to sheet 1 the normal way.
the formula would look like this
=(LEN('Live Meta Data'!$B$1)-LEN(SUBSTITUTE('Live Meta Data'!$B$1,Sheet2!$A1,"")))/LEN(Sheet2!$A1)
=(LEN('Live Meta Data'!$B$5)-LEN(SUBSTITUTE('Live Meta Data'!$B$5,Sheet2!$A2,"")))/LEN(Sheet2!$A2)
=(LEN('Live Meta Data'!$B$7)-LEN(SUBSTITUTE('Live Meta Data'!$B$7,Sheet2!$A3,"")))/LEN(Sheet2!$A3)
=(LEN('Live Meta Data'!$B$9)-LEN(SUBSTITUTE('Live Meta Data'!$B$9,Sheet2!$A4,"")))/LEN(Sheet2!$A4)
Bookmarks