office multiple sheet question

  1. 221 Posts.
    What I'd like to do is after opening 3 or more consecutive ASX EOD .csv files, I want to delete any codes that don't appear in all of the sheets. Therefore any row of any sheet will be a particular ASX code's data, not out of line as when first opened, because of warrants expiring etc.

    I can delete the offending rows on all sheets manually, but it is tedious. So I'm hoping some savvy trader on this forum has mastered multiple sheet consolidation already and can succour me.

    Do I have to run a macro to do this?

    Can anyone recommend any data providers? Now that EquityCafe has changed their site from trading game to research, I am without fresh EOD data.
 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.