putting two photos ontop of each other and having them show a split in one column

I have stretched two photos across excel (in two different worksheets)  I want to put them on top of each other and have them print each column both pictures (column would have worksheet a on the left and workshop be on the right)

It would be like making a lenticular print

any suggestions

Thank you