Need help in fine tuning VBA code that copies row data to new sheet

[naira]

Hi

I need help in fine tuning VBA Code for a workbook that receives Machine Temp & Speed Live data and adds it to a new row in another sheet every 15 seconds.

The Problem is:

1. The data in all the 3 sheets is not being updated every 15 seconds and sometimes the code either stops working permanently or holds for 2-3 steps i.e. 30 seconds to a 60 seconds randomly in some sheet, leading to gaps in my data updation.
2. If I add any complex vlookups or large no. of conditional formatting the workbook crashes.
3. If I stay on any one sheet for more than a minute the data stops updating for that particular sheet.

I have a i5 processor with 8 GB of RAM, so my system memory should not be an issue.

Regards,

Naira

[naira]

Bump!
Help anyone?