Yes, you can!

Try this:
1) Create a workbook with three worksheets.
2) Type some data into the first one or two worksheets.
3) On the third worksheet, pick a cell and type "=". Do not hit <Enter> yet.
4) Leaving that formula unfinished, navigate to another worksheet, either by clicking on the tab or just hitting <Ctrl-PgDn> and <Ctrl-PgUp>.

Note that in the formula bar, your formula is sitting there still waiting to be completed.

5) Once on the selected worksheet, select a cell.

Note that in the formula bar, Excel has filled in the address of the cell you selected.

6) Hit <Enter>. The cell on your third worksheet now points to the cell on the other worksheet. You can use this syntax to combine values on other cells in various ways, just plugging them into formulae. You can even do it from other worksheets, if you want to, though that is not always convenient.

Thank you so very much for the reply back sorry it has taken me so long to reply I have been working alot and free time is been spent loading a new operating system which proved to take days and be a pain in the butt, all set with it for now till the wife finds out and either pulls my hair or says it will be good enough. Must say Windows 8 is a pain in the butt.

Any way i will look that over and reply back again cause I lost my exact idea and dont know how to make that idea work so I have to think on it again.

Thanks again and hope to stay in touch

clo312