CONCANTENATE function in MS Excel

I have created an MS Excel Workbook that includes two spreadsheets.

In the one worksheet I am using the CONCANTENATE function and it works perfectly fine.

I would like to use the same function in my other worksheet but I get one of two results neither of which work (a result based on the first worksheet or the error message "Name? "

I am sure there is a way around this, but for the life of me I cannot figure it out.

Any ideas?

 

Please post the CONCATENATE functions from both work sheets
regards

 

I figured it out

Thank you for your reply. I did finally figure it out.

I needed to use the name of the tab of the worksheet plus an exclamation point before my formula, i.e. =2001!,(rest of function).