Macros to work on individual worksheets

I want to set-up an EXCEL workbook with up to 8 worksheets, where each sheet has it's own independent live data feed coming into it. The data coming in will be displayed in cells A2:K12 on each worksheet and every 'x' seconds I want to copy that data starting at row 21 (Row 20 containing the titles) on each worksheet, so that I build-up a record over a period of 20 minutes or so.
At the moment I have all the data-feeds coming into one worksheet but sometimes the feeds come in at the same time so I end up capturing only one lot of data.

The macro I have is :-

Please Login or Register  to view this content.

Cell AA1 is a formula that returns either 'Copy' or 'No Copy', and controls how often data will be copied, or stop copying.
How do I get this (or similar) macro to operate on each and every worksheet so there is no conflict between the worksheets?

Realise the problem is probably row 30,40 & 60 but my skills on writing macros tend to be, Record macro then do a bit of manual editting.

Using EXCEL 2002.

New to Forum, missed the tags for code on OP!!!

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.