VBA Example for Drill Through

Does anyone have a working VBA example for replicating the drill through functionality? What I am trying to do is pass specific members via variables into some sort of drill through function that will mimic the operation of drilling from an ad hoc grid where it displays the source detail on a new sheet. I want avoid using an ad hoc grid and just pass variables straight into a VBA function and have it return the source detail as though I was using an ad hoc grid. I was trying to use the documentation online, but I'm struggling to follow