Multiple Queries in same workbook but in different sheets
I am working on workbooks in Bex. I have around 15 queries. The requirement being :
Queries 1 to 10 -> Workbook1 Sheet1 . ( This is done and works fine)
Query 2 -> Workbook 1 Sheet 2.
Query 3 -> Workbook 1 Sheet 3.
Here when I insert query in sheet 2, the queries from sheet 1 disappears.
How to insert multiple queries in different sheets in the same workbook?