Help with creating a macro to anaylse and pull data from multiple worksheets

Hi Arlete,

Thank you so much with all your help.

I have attached 2 spreadsheets as an example of what I'm after. I need to have a macro in Test2 that will look through Test and detail accounts which have a percentage discrepancy i.e cell D35 is not equal to 100% (sometimes it can be less than and sometimes it can be greater than 100) and list the accounts details back into the Test2 spreadsheet.

On the Test spreadsheet there are 3 tabs but on the spreadsheet im working on there are over 80. I take it the code you have used so far won't make a difference for the amount of tabs there are?

The macro does not need to open Test2 as this will already be open.

If you can add the two conditions into the one macro that would be great.

If you can add the code to refresh the data to start of with that would be great to.

Your help is much appreciated.

Thanks,

Eoghan