Is it possible to create a report in one app using a table from another app?

My big advise is to NOT duplicate your app for every store.  Just control access by Role permissions.  The reason is that if you have 10 stores or 100 stores you will start to run out app your app limits but more importantly run out of sanity by having to make 10 changes for every change to the app.

The Role Permission can be done in just 1 Role, but that is a topic for another question.