Need to trade from Excel to mt5

I have 2 excel spreadsheets from which I would like to automatically send trades -open and close them - based on a value in the sheet which will say:

buy

sell

when either buy or sell appears in the cell, I would like to send that trade as well a specify  (manually entered before the trade in other cells) the volume, take profit and stop loss.

This is for up to 12 different pairs.

For any one particular pair, I would also like the ability to reverse the trade should the opposite signal appear (buy to sell or vice versa).

I would also like the ability to close a trade that was inputed without a takeprofit, should another cell  say outB or outS, meaning exit and do nothing until a new Buy or Sell appears

I would like the ability to also point the commands to any cell within the sheet, as well as an explanation of how to modify the variables should I need to in the future.

I can send a picture of the spreadsheets or a spreadhseet with dummy values and no formulas.  Something similar to Excel RTD without having to manually send the trade but rather have the trade be based on the output result of another cell.