to find Sheet ref and Cell ref from a formula

Dear Friends,

Is there a formula which would give me file name, sheet name, cell ref. separately from a formula.

e.g
A1 = +'G:\R COST CODE\2016-17\[R Cost Branchwise 1617.xlsm]225'!M4 (which is the formula)
B1 : R Cost Branchwise 1617.xlsm (which is file name)
C1 : 225 (which is sheet no.)
D1 : M4 (which is cell ref.)

In my day-to-day work, my file is linked to many files and each file has many many sheets.

The file is too heavy due to links
I plan to break the links by doing paste special formula, but retain there file name, sheet name and cell ref.

Please help.

It will not serve my purpose.

File name, Sheet name and cell ref. will changes everytime.

I need a formula which will separate the File name, Sheet name and cell ref. from a formula.

Please help.

Just to clear confusion

In A1 formula is already been there. ("+'G:\R COST CODE\2016-17\[R Cost Branchwise 1617.xlsm]225'!M4" )

I need to fill
B1 : R Cost Branchwise 1617.xlsm (which is file name)
C1 : 225 (which is sheet no.)
D1 : M4 (which is cell ref.)

Its returning me #VALUE!

Please assist.

A1 has a formula. Its not a text value.