RegEx - references & ranges from formula

RegEx is still a world of mystery to me but I use a function cotaining RegEx which could be helpfully modified
(credit ExtendOffice)

The function returns a string of cell references separated by commas
I would prefer 2 functions each returning a sub-set of those references
- specifically ranges AND individual cells
- the string should include sheet references if in the original formula

Examples

Formula:

Please Login or Register  to view this content.

Function returns: A1, AA1:AA10, $AA1:$AA10, $AA$1:$XEP$20000
Required RANGES: AA1:AA10, $AA1:$AA10, $AA$1:$XEP$20000
Required CELLS: A1

Formula:

Please Login or Register  to view this content.

Function returns: DataTab!A1, DataTab!AA1:AA10, DataTab!$AA1:$AA10, DataTab!$AA$1:$XEP$20000
Required RANGES: DataTab!AA1:AA10, DataTab!$AA1:$AA10, DataTab!$AA$1:$XEP$20000
Required CELLS: DataTab!AA1

My current workaround is to manipulate the resultant string, but it would be tidier if each function generated the string required.

Thank you

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you jindon

The function works perfectly for ranges where the formula contains a sheet reference

BUT....
returns nothing for formula where reference is in the SAME sheet
example

Formula:

Please Login or Register  to view this content.

should return
AA1:AA10, $AA1:$AA10, $AA$1:$XEP$20000

That is perfect for RANGES - Thank you

Could you now give me the pattern that does exactly the same for individual cell references

with formula

Formula:

Please Login or Register  to view this content.

function should return
A1,A2,DataTab!A1,DataTab!A2,DataTab!E2,Sheet1!F2

@jindon - thank you - it is very close

with formula
=A1+A2+DataTab!A1+VLOOKUP(DataTab!A2,DataTab!C2:D12,DataTab!E2,Sheet1!F2)

function returns:
A1, A2, DataTab!A1, DataTab!A2, DataTab!C2:D12, DataTab!E2, Sheet1!F2

this is what I want:
A1,A2,DataTab!A1,DataTab!A2,DataTab!E2,Sheet1!F2

There should be no ranges in the string

Then

Please Login or Register  to view this content.

@jindon - thank you - that is exactly what I wanted