I am trying to create a formula in which I am able to copy data from one
worksheet to a cell of a different worksheet in the SAME workbook based on
specific criteria.

For example, if cell A2 on Worksheet A contains item data, I want to copy
that exact data to Worksheet B cell D50. I need to use a formula as there
will be additional criteria added later on.

How should I proceed?