I want to work in access to link two different worksheets in which there is common field and the result should be shown in third worksheet

You can link a worksheet within Access. You can then create a query that links the two on the key field. But you don't need a 3rd spreadhseet, just the query.