CLICKS A CELL AND TO OPEN UPEN UP IN A NEW SHEET

LOOKING FOR STOCK LOG. WANT TO CLICK CELL AND TO OPEN UP TO ANOTHER WORK SHEET SO WHEN BUYING AND SELLING A STOCK MULTIPY TIME AND IF POSSIBLE TO REPEAT ROW HEADINGS.

Need any cell in Row A to open up  to with columns so that I can enter multi buy and sell info to  another  spread sheet or any other ideas so.

what I can do is use the Rows and repeat date , buy and sell  but it is not effective.